OCP 1Z0 052 99

99. 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 independently 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 export utility of previous 
versions. 
E.EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import 
commands. 
Answer: AB

C 只要用户有对应权限，都可以执行Data Pump

D
http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_export.htm#SUTIL3635

What is the Export Utility?

The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations.

When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any.

An Export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures.

Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file.

You can also display the contents of an export file without actually performing an import. To do this, use the Import SHOW parameter. See "SHOW" for more information.To load data from ASCII fixed-format or delimited files, use the SQL*Loader utility.

E 应该是 dbms_datapump

http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL801

Data Pump Components

Oracle Data Pump is made up of three distinct parts:

• The command-line clients, expdp and impdp

• The DBMS_DATAPUMP PL/SQL package (also known as the Data Pump API)

• The DBMS_METADATA PL/SQL package (also known as the Metadata API)

The Data Pump clients, expdp and impdp, invoke the Data Pump Export utility and Data Pump Import utility, respectively.

The expdp and impdp clients use the procedures provided in the DBMS_DATAPUMP PL/SQL package to execute export and import commands, using the parameters entered at the command line. These parameters enable the exporting and importing of data and metadata for a complete database or for subsets of a database.

When metadata is moved, Data Pump uses functionality provided by the DBMS_METADATA PL/SQL package. The DBMS_METADATApackage provides a centralized facility for the extraction, manipulation, and re-creation of dictionary metadata.

The DBMS_DATAPUMP and DBMS_METADATA PL/SQL packages can be used independently of the Data Pump clients.

Note:

All Data Pump Export and Import processing, including the reading and writing of dump files, is done on the system (server) selected by the specified database connect string.  This means that for unprivileged users, the database administrator (DBA) must create directory objects for the Data Pump files that are read and written on that server file system. (For security reasons, DBAs must ensure that only approved users are allowed access to directory objects.) For privileged users, a default directory object is available. See  "Default Locations for Dump, Log, and SQL Files" for more information about directory objects.