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.
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)- A86% (24)
- C4% (1)
- D7% (2)
- E4% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.