Oracle Database 12c: Advanced Administration — Question 99

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

Answer options

• A. You cannot export data from a remote database.
• B. You can rename tables during import.
• C. You can overwrite existing dump files during export.
• D. You can compress data but not metadata during export.

Correct answer: A, B

Explanation

Statement A is correct because exporting data from a remote database is not supported by Oracle Data Pump. Statement B is also true as it allows renaming of tables during the import. The other statements are incorrect; C is wrong because existing dump files cannot be overwritten, and D is incorrect since both data and metadata can be compressed.