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

The correct answer is B. You can rename tables during import. C. You can overwrite existing dump files during export. However, in Oracle 11g there is a new parameter, reuse_dumpfiles, which overwrites any created dump file in a specified folder. This parameter accepts two values: Y and N. Default is N. If the parameter was set to Y, then Data Pump overwrites the files that already exist.

New Features for Manageability

Question

Options

AYou cannot export data from a remote database.
BYou can rename tables during import.
CYou can overwrite existing dump files during export.
DYou can compress data but not metadata during export.

How the community answered

(17 responses)

A
12% (2)
B
71% (12)
D
18% (3)

Explanation

However, in Oracle 11g there is a new parameter, reuse_dumpfiles, which overwrites any created dump file in a specified folder. This parameter accepts two values: Y and N. Default is N. If the parameter was set to Y, then Data Pump overwrites the files that already exist.

Topics

#Data Pump#export import operations#dump file overwrite#table rename

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice