nerdexam
Oracle

1Z0-052 · Question #16

Which two statements are true regarding Oracle Data Pump? (Choose two.)

The correct answer is 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. Oracle Data Pump consists of client utilities (expdp/impdp) and the DBMS_DATAPUMP PL/SQL API, which can be invoked independently of the command-line clients.

Moving Data

Question

Which two statements are true regarding Oracle Data Pump? (Choose two.)

Options

  • AEXPDP and IMPDP are the client components of Oracle Data Pump
  • BDBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients
  • COracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege
  • DOracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x
  • EEXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import

How the community answered

(28 responses)
  • A
    86% (24)
  • C
    4% (1)
  • D
    7% (2)
  • E
    4% (1)

Why each option

Oracle Data Pump consists of client utilities (expdp/impdp) and the DBMS_DATAPUMP PL/SQL API, which can be invoked independently of the command-line clients.

AEXPDP and IMPDP are the client components of Oracle Data PumpCorrect

EXPDP and IMPDP are the command-line client executables that serve as the user interface for Data Pump; they are the client-side components that submit jobs to the Data Pump server processes running inside the database.

BDBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clientsCorrect

The DBMS_DATAPUMP PL/SQL package exposes a complete API for export and import operations that developers or DBAs can call directly from PL/SQL code without ever invoking the expdp or impdp command-line utilities.

COracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege

Data Pump operations do not require SYSDBA; users need the EXP_FULL_DATABASE or IMP_FULL_DATABASE system privilege for full database exports/imports, or they can export their own schema objects without any special privilege.

DOracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x

Oracle Data Pump uses its own proprietary binary dump format and cannot read dump files produced by the original exp utility from release 9.x or earlier; those legacy files require the original imp utility.

EEXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import

EXPDP and IMPDP use DBMS_DATAPUMP as their underlying execution engine, not DBMS_METADATA; DBMS_METADATA is a separate package used for DDL extraction and is not the primary driver of Data Pump operations.

Concept tested: Oracle Data Pump architecture and component roles

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-overview.html

Topics

#Data Pump#EXPDP#IMPDP#DBMS_DATAPUMP

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice