nerdexam
Oracle

1Z0-062 · Question #216

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

The correct answer is D. Tables cannot be renamed during an import operation. E. Metadata that is exported andimported can be filtered based on objects and object types. Oracle Data Pump supports metadata filtering via INCLUDE/EXCLUDE parameters, but table renaming during import is not a native Data Pump capability in the exam version covered.

Moving Data

Question

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

Options

  • AYou cannot specify how partitioned tables shouldbe handled during an import operation.
  • BOnly data can be compressed during an export operation.
  • CExisting dump files can be overwritten during an export operation.
  • DTables cannot be renamed during an import operation.
  • EMetadata that is exported andimported can be filtered based on objects and object types.

How the community answered

(24 responses)
  • B
    4% (1)
  • D
    96% (23)

Why each option

Oracle Data Pump supports metadata filtering via INCLUDE/EXCLUDE parameters, but table renaming during import is not a native Data Pump capability in the exam version covered.

AYou cannot specify how partitioned tables shouldbe handled during an import operation.

Data Pump provides the PARTITION_OPTIONS parameter (with values DEPARTITION, MERGE, or NONE) to explicitly control how partitioned tables are handled during an import operation.

BOnly data can be compressed during an export operation.

Data Pump supports compression of both data and metadata through the COMPRESSION parameter, which accepts ALL, DATA_ONLY, METADATA_ONLY, and NONE as valid values, not just data.

CExisting dump files can be overwritten during an export operation.

Data Pump does not overwrite existing dump files by default and will raise an error if the target file already exists; the REUSE_DUMPFILES=Y parameter must be explicitly set to allow overwriting.

DTables cannot be renamed during an import operation.Correct

Data Pump does not provide a parameter to rename tables during an import operation in the version this exam targets; there is no built-in REMAP_TABLE equivalent available, so tables retain their original names on import.

EMetadata that is exported andimported can be filtered based on objects and object types.Correct

Data Pump supports the INCLUDE and EXCLUDE parameters, which allow filtering of metadata based on specific object names and object types such as TABLE, INDEX, or PROCEDURE, giving fine-grained control over what is exported or imported.

Concept tested: Oracle Data Pump export/import options and metadata filtering

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

Topics

#Oracle Data Pump#export#import#metadata filtering#table renaming

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice