nerdexam
Oracle

1Z0-062 · Question #349

Which three statements are true about Oracle Data Pump? (Choose three.)

The correct answer is A. Oracle Data Pump export and import operations can be performed to move data across B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients. C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have. Oracle Data Pump allows high-speed data transfer across databases, can be controlled programmatically via PL/SQL, and requires a pre-existing directory object for file operations with appropriate user permissions.

Moving Data

Question

Which three statements are true about Oracle Data Pump? (Choose three.)

Options

  • AOracle Data Pump export and import operations can be performed to move data across
  • BDBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.
  • CA directory object must exist and a user performing an EXPDP or IMPDP operation must have
  • DOracle Data Pump export and import operations can be performed only by users with the
  • EOracle Data Pump export operations invoked from the clients that are connected remotely by

How the community answered

(39 responses)
  • A
    90% (35)
  • D
    3% (1)
  • E
    8% (3)

Why each option

Oracle Data Pump allows high-speed data transfer across databases, can be controlled programmatically via PL/SQL, and requires a pre-existing directory object for file operations with appropriate user permissions.

AOracle Data Pump export and import operations can be performed to move data acrossCorrect

Oracle Data Pump is a utility designed for very high-speed movement of data and metadata between Oracle databases, making it suitable for tasks like migrations, upgrades, and cloning.

BDBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.Correct

The `DBMS_DATAPUMP` PL/SQL package provides an Application Programming Interface (API) that allows developers to programmatically control and manage Data Pump jobs, independent of the command-line clients `expdp` and `impdp`.

CA directory object must exist and a user performing an EXPDP or IMPDP operation must haveCorrect

All Oracle Data Pump export and import operations require a server-side database directory object to specify the location on the file system where dump files, log files, and SQL files are stored, and the user executing the operation must have `READ` and `WRITE` privileges on this directory.

DOracle Data Pump export and import operations can be performed only by users with the

While specific Data Pump roles exist, users with appropriate object privileges or `EXP_FULL_DATABASE`/`IMP_FULL_DATABASE` roles can also perform Data Pump operations, not exclusively users with the specified roles.

EOracle Data Pump export operations invoked from the clients that are connected remotely by

Oracle Data Pump export operations invoked from `expdp` clients can connect remotely to a database server to perform the export, allowing for flexible architectural deployments.

Concept tested: Oracle Data Pump architecture and requirements

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

Topics

#Oracle Data Pump#EXPDP#IMPDP#directory object

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice