Which two statements are true regarding the Oracle Data Pump export and import
operations?
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.
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#BEHFFDCD
B,C
B and C
BC
B C
B,C
C here
http://www.dba-oracle.com/T_rman_167_expdp_reuse_dumpfiles_parameter.htm
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.
B&C are Correct!
Read through here https://oracle-base.com/articles/11g/data-pump-enhancements-11gr1 It says it all
Its not different in 12c
B and C Are Correct!
Read Through this https://oracle-base.com/articles/11g/data-pump-enhancements-11gr1
BC
https://docs.oracle.com/cd/E57425_01/121/SUTIL/GUID-55EA54B5-BC13-48F1-AF14-485C16170274.htm
https://docs.oracle.com/cd/E49329_01/server.121/b71303/dp_import.htm#BEHCFDAC
BC
https://docs.oracle.com/cd/E16338_01/server.112/b56299/statements_3002.htm
https://docs.oracle.com/cd/E49329_01/server.121/b71303/dp_import.htm#BEHCFDAC
BC