Oracle
1Z0-062 · Question #151
1Z0-062 Question #151: Real Exam Question with Answer & Explanation
The correct answer is A: You can detach from a data pump export job and reattach later.. Oracle Data Pump supports job detach and reattach for both export and import, and always writes the master table last during export to ensure complete job metadata.
Question
Which three statements are true about Oracle Data Pump export and import operations?
Options
- AYou can detach from a data pump export job and reattach later.
- BData pump uses parallel execution server processes to implement parallel import.
- CData pump import requires the import file to be in a directory owned by the oracle owner.
- DThe master table is the last object to be exported by the data pump.
- EYou can detach from a data pump import job and reattach later.
Explanation
Oracle Data Pump supports job detach and reattach for both export and import, and always writes the master table last during export to ensure complete job metadata.
Common mistakes.
- B. Data Pump uses its own dedicated worker processes for parallel operations, not the general-purpose parallel execution server processes used by parallel query and DML operations.
- C. Data Pump requires the dump file to reside in a location accessible via an Oracle directory object granted to the user - there is no requirement that the OS directory be owned by the oracle user.
Concept tested. Oracle Data Pump job management and master table export behavior
Reference. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-data-pump-overview.html
Community Discussion
No community discussion yet for this question.