nerdexam
Oracle

1Z0-060 · Question #195

Which two statements are true about Oracle Data Pump export and import operations?

The correct answer is A. You can detach from a Data Pump export job and reattach later. B. Data Pump uses parallel execution server processes to implement parallel import. Oracle Data Pump supports client detach and reattach for export jobs and uses parallel execution server processes to accelerate import operations.

New Features for Manageability

Question

Which two statements are true about Oracle Data Pump export and import operations?

Options

  • AYou can detach from a Data Pump export job and reattach later.
  • BData Pump uses parallel execution server processes to implement parallel import.
  • CData pump import requires an import file to be in a directory owned by the oracle owner.
  • DData Pump always automatically uses the direct path method for loading and unloading all types
  • EYou can detach from a data pump import job and reattach later.

How the community answered

(36 responses)
  • A
    94% (34)
  • C
    3% (1)
  • D
    3% (1)

Why each option

Oracle Data Pump supports client detach and reattach for export jobs and uses parallel execution server processes to accelerate import operations.

AYou can detach from a Data Pump export job and reattach later.Correct

Data Pump export runs as a persistent master control process that continues independently of the initiating client; the client can exit and later reconnect using the EXPDP ATTACH=job_name parameter, allowing long exports to run unattended without losing job state.

BData Pump uses parallel execution server processes to implement parallel import.Correct

When the PARALLEL parameter is specified for an import, Data Pump spawns Oracle parallel execution (PX) server processes that simultaneously load data into separate table segments or partitions, directly reducing total import elapsed time for large data sets.

CData pump import requires an import file to be in a directory owned by the oracle owner.

Data Pump file access is governed entirely by Oracle DIRECTORY objects pointing to OS paths; the underlying directory only needs to be accessible to the Oracle process - there is no requirement that it be owned by the oracle OS account.

DData Pump always automatically uses the direct path method for loading and unloading all types

Data Pump selects the load or unload method per object type; referential integrity constraints, bitmap indexes, and certain data types force use of the conventional path method, so direct path is not applied universally to all object types.

EYou can detach from a data pump import job and reattach later.

Unlike export jobs, Data Pump import jobs do not support the ATTACH parameter for reconnecting a detached client session; once the initiating session ends, the client cannot reattach to regain interactive control of the import job.

Concept tested: Oracle Data Pump detach-reattach capability and parallel import execution

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

Topics

#Data Pump#export detach#parallel import#direct path

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice