Which three 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.
Question is probably wrong as E is also right. You can detach from both data pump import & export jobs and reattach later.
B may be wrong because it uses for both EXPDP and IMPDP.
So what exactly in that question
A.
You can detach from a data pump export job and reattach later.YES reattach later
B.
Data pump uses parallel execution server processes to implement parallel import. Yes Parallel Import & Export
C.
Data pump import requires the import file to be in a directory owned by the oracle owner………………..NO
D.
The master table is the last object to be exported by the data pump…….YES
E.
You can detach from a data pump import job and reattach later…..i think NO for import its only for export
ADE
B: worker processes
I’ve checked it by myself. Yes, I can reattach to impdp.
AE are correct. http://www.oracle.com/technetwork/issue-archive/2009/09-jul/datapump11g2009-quickstart-128718.pdf
B not (fully) correct: parallel execution consists of a combination of worker processes and parallel I/O server processes (http://docs.oracle.com/database/121/SUTIL/dp_import.htm#SUTIL921)
D is correct. (page 1011 https://books.google.fr/books?id=HwOCAwAAQBAJ&pg=PA1011&lpg=PA1011&dq=oracle+data+pump+master+table+12c&source=bl&ots=de9WMMAeOS&sig=Tg_Fq9qTRJiHXB8g4xKko1udrfs&hl=fr&sa=X&ei=QV5gVerjHILxUv_tgYgO&ved=0CGoQ6AEwCQ#v=snippet&q=master%20table&f=false)
ADE
ADE