nerdexam
Oracle

1Z0-072 · Question #9

DATADIR1 and DATADIR2 are database directory objects. Examine this command: [oracle@host01 ~]$ expdp system/oracle \ > FULL=y \ > DUMPFILE=datadir1:full%U.dmp, datadir2:full2%U.dmp \ > FILESIZE=2G \…

The correct answer is A. It creates a dump file for the entire database. E. It starts only when four worker processes are available. See the full explanation below for the reasoning.

Question

DATADIR1 and DATADIR2 are database directory objects. Examine this command: [oracle@host01 ~]$ expdp system/oracle \ > FULL=y \ > DUMPFILE=datadir1:full%U.dmp, datadir2:full2%U.dmp \ > FILESIZE=2G \ > PARALLEL=4 \ > LOGFILE=datadir1:expfull.log \ > JOB_NAME=expfull Which two are true about the expdp operation? (Choose two.)

Options

  • AIt creates a dump file for the entire database.
  • BIt fails if the total size of the dump file is more than 2 GB.
  • CIt creates a dump file only for objects in the SYSTEM schema.
  • DIt creates a master table to store details of the export operation.
  • EIt starts only when four worker processes are available.

How the community answered

(58 responses)
  • A
    81% (47)
  • B
    3% (2)
  • C
    3% (2)
  • D
    12% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-072 Practice