Identify three key features of Oracle Data Pump (Choose three.)

Identify three key features of Oracle Data Pump (Choose three.)

Identify three key features of Oracle Data Pump (Choose three.)

A.
Data Pump can stop a running job and resume it later

B.
Data Pump can perform import using database link

C.
Data Pump uses absolute path instead of relative path

D.
Data Pump uses relative path instead of absolute path

E.
Data Pump can perform incremental and cumulative exports

Explanation:
+ The ability to restart Data Pump jobs. The START_JOB command restarts the current job to which you are attached (the job cannot be currently executing). The job is restarted with no data loss or corruption after an unexpected failure or after you issued a STOP_JOB command, provided the dump file set and master table have not been altered in any way.
+ The NETWORK_LINK parameter initiates an export using a database link. This means that the system to which the expdp client is connected contacts the source database referenced by the source_database_link, retrieves data from it, and writes the data to a dump file set back on the connected system.
+ When data is moved, Data Pump automatically uses either direct path load (or unload) or the external tables mechanism, or a combination of both.

REF: Oracle(r) 10g Database Utilities ,1-2 and 1-3



Leave a Reply 0

Your email address will not be published. Required fields are marked *