nerdexam
Oracle

1Z0-067 · Question #157

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 correct answer is D. It succeeds and exports the full database, simultaneously creating three dump files at three. It can create more than 3 files because you say that each file has a maximum of 400 MB. For example in my export that had 1,2 gb it created 4 files. %u makes 01, 02, 03 and so on.

New Features for Manageability

Question

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?

Options

  • AIt fails because the log file parameter is not specified.
  • BIt fails because no absolute path is specified for the log file and dump file.
  • CIt succeeds and exports the full database, simultaneously creating three copies of dump files at
  • DIt succeeds and exports the full database, simultaneously creating three dump files at three

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    16% (4)
  • D
    72% (18)

Explanation

It can create more than 3 files because you say that each file has a maximum of 400 MB. For example in my export that had 1,2 gb it created 4 files. %u makes 01, 02, 03 and so on.

Topics

#Data Pump export#PARALLEL#multiple dump files#FILESIZE

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice