Which one is the correct option for taking unload from the table EMPTAB

technology databases

  1. UNLOAD TABLE DSN1DB04.EMPTABSP

  2. UNLOAD TABLESPACE DSN1DB04.EMPTABSP

  3. UNLOAD DATABASE DSN1DB04.EMPTABSP

  4. UNLOAD DATABASE DSN1DB04 EMPTABSP

Show answer
Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) UNLOAD TABLE DSN1DB04.EMPTABSP - This option is incorrect because the syntax "UNLOAD TABLE" is not valid. The correct syntax is "UNLOAD TABLESPACE" to specify unloading a tablespace.

Option B) UNLOAD TABLESPACE DSN1DB04.EMPTABSP - This option is correct because it uses the correct syntax "UNLOAD TABLESPACE" to specify unloading a tablespace.

Option C) UNLOAD DATABASE DSN1DB04.EMPTABSP - This option is incorrect because the syntax "UNLOAD DATABASE" is not valid for unloading a specific table or tablespace. It is used for unloading the entire database.

Option D) UNLOAD DATABASE DSN1DB04 EMPTABSP - This option is incorrect because it does not specify the tablespace properly. The correct syntax for specifying a tablespace is "DSN1DB04.EMPTABSP" instead of "DSN1DB04 EMPTABSP".

The correct answer is Option B) UNLOAD TABLESPACE DSN1DB04.EMPTABSP. This option is correct because it uses the correct syntax for unloading a specific tablespace.

Find more quizzes: