Oracle Database 12c: Advanced Administration — Question 150

Which two statements are true regarding Oracle Data Pump?

Answer options

• 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 Original Export Utility.
• E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Correct answer: A, B

Explanation

The correct answers, A and B, accurately describe the functioning of Oracle Data Pump, indicating that EXPDP and IMPDP are indeed client components and that DBMS_DATAPUMP can operate independently. The other options are incorrect because C is misleading as users with specific roles can perform operations, D is false since Oracle Data Pump does not support importing from the Original Export Utility, and E is incorrect as EXPDP and IMPDP do not rely on DBMS_METADATA for their operations.