Which two statements are true about Oracle Data Pump export and import operations?
A.
You can detach from a data pump export job and reattach later.
B.
Data pump uses parallel execution server processes to implement parallel import.
C.
Data pump import requires the import file to be in a directory owned by the oracle owner.
D.
The master table is the last object to be exported by the data pump.
E.
You can detach from a data pump import job and reattach later.
Explanation:
B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.
D: For export jobs, the master table records the location of database objects within a dump file set. / Export
builds and maintains the master table for the duration of the job. At the end of an export job, the content of the
master table is written to a file in the dump file set.
/ For import jobs, the master table is loaded from the dump file set and is used to control the sequence of
operations for locating objects that need to be imported into the target database.
I can understand A&B, but why is D not correct?
B is not correct. PARALLEL=integer
The value you specify for integer specifies the maximum number of processes of active execution operating on behalf of the import job. This execution set consists of a combination of worker processes and parallel I/O server processes. The master control process, idle workers, and worker processes acting as parallel execution coordinators in parallel I/O operations do not count toward this total.
i suggest we should choose 2 out of A, D, and E.
here is the question from previous version. there are even 3 correct asnwers. i in little depression what is correct in this exam.
https://equizzing.com/oracle/which-three-statements-are-true-about-oracle-data-pump-export-and-import-operations-5/
Article on this starts here: https://docs.oracle.com/database/121/SUTIL/GUID-6BDC1CC8-8596-402D-B016-602985B97AB6.htm#SUTIL813
I believe A and B are correct in 12c, as master table outcome is situational dependent.