Which two statements are true regarding Oracle Data Pump? (Choose two.)
A.
EXPDP and IMPDP are the client components of Oracle Data Pump
B.
DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients
C.
Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege
D.
Oracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x
E.
EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands
Oracle Data Pump is made up of the following distinct parts:
– The command-line clients expdp and impdp
These client make calls to the DBMS_DATAPUMP package to perform Oracle Data
Pump operations (see “PL/SQL Packages” on page 8-6).
– The DBMS_DATAPUMP PL/SQL package, also known as the Data Pump API
This API provides high-speed import and export functionality.
– The DBMS_METADATA PL/SQL package, also known as the Metadata API
This API, which stores object definitions in XML, is used by all processes that load
and unload metadata
Hi,
As per http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm
A&B are correct.
(provided that in B, indedendently = independently 😛 )
E is also correct
http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm
When data is moved, Data Pump automatically uses either direct path load (or unload) or the external tables mechanism, or a combination of both. When metadata is moved, Data Pump uses functionality provided by the DBMS_METADATA PL/SQL package. The DBMS_METADATA package provides a centralized facility for the extraction, manipulation, and resubmission of dictionary metadata.
The DBMS_DATAPUMP and DBMS_METADATA PL/SQL packages can be used independently of the Data Pump clients.
E is not correct:
“The expdp and impdp clients use the procedures provided in the DBMS_DATAPUMP PL/SQL package to execute export and import COMMANDS”
“The DBMS_METADATA package provides a centralized facility for the extraction, manipulation, and resubmission of dictionary METADATA.”