Upgrade Oracle DBA 11g to Oracle Database 12c — Question 22

Examine the command:
$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3

JOB_NAME=expfull -
Which statement is true about the execution of the command?

Answer options

• A. It fails because the log file parameter is not specified.
• B. It fails because no absolute path is specified for the log file and dump file.
• C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
• D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed

Correct answer: B

Explanation

The correct answer is B because the command does not specify an absolute path for the log file and dump files, which is necessary for successful execution. Option A is incorrect as the log file parameter is not mandatory; options C and D are incorrect since they suggest success when the command would actually fail due to the path issue.