Oracle Database 12c: Installation and Administration — Question 61

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

Answer options

• A. You cannot specify how partitioned tables should be handled during an import operation.
• B. Only data can be compressed during an export operation.
• C. Existing dump files can be overwritten during an export operation.
• D. Tables cannot be renamed during an import operation.
• E. Metadata that is exported and imported can be filtered based on objects and object types.

Correct answer: C, E

Explanation

Option C is correct because existing dump files can indeed be overwritten when performing an export operation. Option E is also accurate as it allows for filtering of metadata based on specific objects and their types. Options A and D are incorrect because you can specify how partitioned tables are handled during import, and tables can be renamed during the import operation, which contradicts those statements. Option B is wrong since both data and metadata can be compressed.