nerdexam
Oracle

1Z0-052 · Question #193

In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

The correct answer is B. if a table has an active trigger C. if a table has an encrypted column E. if a table has a referential integrity constraint defined on it. Oracle Data Pump falls back to the external tables method when a table has features that are incompatible with the direct path load mechanism.

Moving Data

Question

In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

Options

  • Aif a table is not in a cluster
  • Bif a table has an active trigger
  • Cif a table has an encrypted column
  • Dif a table has a column of data type LONG defined on it
  • Eif a table has a referential integrity constraint defined on it

How the community answered

(40 responses)
  • A
    8% (3)
  • B
    83% (33)
  • D
    10% (4)

Why each option

Oracle Data Pump falls back to the external tables method when a table has features that are incompatible with the direct path load mechanism.

Aif a table is not in a cluster

A table NOT being in a cluster is the normal condition for direct path load; it is tables that ARE physically stored in a cluster that cannot use direct path and require the external tables method.

Bif a table has an active triggerCorrect

Direct path load bypasses row-level SQL processing and does not fire DML triggers; when an active trigger exists on a table, Data Pump must use the external tables method to ensure the trigger executes properly during export.

Cif a table has an encrypted columnCorrect

Columns protected by Transparent Data Encryption (TDE) cannot be read correctly via direct path; Data Pump uses the external tables method to handle the encryption layer properly.

Dif a table has a column of data type LONG defined on it

The presence of a LONG datatype column does not force Data Pump export to switch from direct path to the external tables method; this restriction does not apply to the export access path selection.

Eif a table has a referential integrity constraint defined on itCorrect

Direct path load bypasses constraint enforcement, so when referential integrity constraints are defined on a table, Data Pump uses the external tables method to maintain correct constraint-aware data access.

Concept tested: Oracle Data Pump access method selection direct path vs external tables

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

Topics

#Data Pump export#external tables#direct path load#table constraints

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice