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.
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)- B4% (1)
- D96% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.