QUESTION 136-Data Pump

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 detech from a data pump import job and reattach later.

 

 

 

Correct Answer: ADE

 

 

 

To use the Data Pump API, you use the procedures provided in the DBMS_DATAPUMP package. The following steps list the basic activities involved in using the Data Pump API. The steps are presented in the order in which the activities would generally be performed:

1/Execute the DBMS_DATAPUMP.OPEN procedure to create a Data Pump job and its infrastructure.

2/Define any parameters for the job.

3/Start the job.

4/Optionally, monitor the job until it completes.

5/Optionally, detach from the job and reattach at a later time.

6/Optionally, stop the job.

7/Optionally, restart the job, if desired.