1Z0-062 · Question #151
Which three statements are true about Oracle Data Pump export and import operations?
The correct answer is A. You can detach from a data pump export job and reattach later. 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.. 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.
How the community answered
(23 responses)- A87% (20)
- B4% (1)
- C9% (2)
Why each option
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.
Data Pump export jobs can be detached using CTRL-C and later reattached using the ATTACH parameter with the job name, allowing administrators to disconnect without stopping the running job.
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.
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.
The master table is always the last object written during a Data Pump export because it contains the complete catalog of all exported objects and is finalized only after all data and metadata have been successfully processed.
Data Pump import jobs, like export jobs, support the detach and reattach mechanism via the ATTACH parameter, letting DBAs disconnect and reconnect to a running import without interrupting it.
Concept tested: Oracle Data Pump job management and master table export behavior
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-data-pump-overview.html
Topics
Community Discussion
No community discussion yet for this question.