1Z0-052 · Question #112
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)
The correct answer is B. You can rename tables during an import operation. C. You can overwrite existing dump files during an export operation. Oracle Data Pump supports table renaming at import time via REMAP_TABLE and allows overwriting existing dump files during export via REUSE_DUMPFILES.
Question
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)
Options
- AYou cannot export data from a remote database.
- BYou can rename tables during an import operation.
- CYou can overwrite existing dump files during an export operation.
- DYou can compress the data during export but not the metadata because it is not supported.
How the community answered
(37 responses)- A5% (2)
- B86% (32)
- D8% (3)
Why each option
Oracle Data Pump supports table renaming at import time via REMAP_TABLE and allows overwriting existing dump files during export via REUSE_DUMPFILES.
Data Pump can export data from a remote database by specifying a NETWORK_LINK parameter pointing to a valid database link, so remote exports are fully supported.
The REMAP_TABLE parameter in a Data Pump import operation allows you to specify a new name for a table as it is loaded into the target schema, enabling renaming without a separate ALTER TABLE statement.
Specifying REUSE_DUMPFILES=Y on the expdp command instructs Data Pump to overwrite any existing dump file with the same name, rather than returning an error when the file already exists.
Data Pump supports compressing both data and metadata through the COMPRESSION parameter, which accepts ALL, DATA_ONLY, METADATA_ONLY, or NONE, so compressing metadata is not unsupported.
Concept tested: Oracle Data Pump export and import advanced options
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.