Upgrade Oracle DBA 11g to Oracle Database 12c — Question 25

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

Option A is correct because Oracle Data Pump does not support exporting data directly from a remote database. Option B is also correct because renaming tables during the import process is a feature of Oracle Data Pump. The other options are incorrect; you can overwrite existing dump files (C), and you can compress both data and metadata during export (D).