Which two statements are true about Oracle Data Pump export and import operations?
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.
Agree
CORRECT ANSWERS: CE
The following two references confirm why C and E are correct:
https://docs.oracle.com/database/121/SUTIL/GUID-65DCC12E-E370-46E0-86C0-4EDFDD78DF25.htm#SUTIL862
REUSE_DUMPFILES
================
Purpose: Specifies whether to overwrite a preexisting dump file.
https://docs.oracle.com/database/121/UPGRD/expimp.htm#UPGRD12560
“Supports filtering the metadata that is exported and imported based upon objects and object types, using INCLUDE and EXCLUDE parameters”
Answer A is incorrect according to this reference: https://docs.oracle.com/database/121/SUTIL/GUID-0271FAC1-3238-49AD-B317-7A018D359740.htm#SUTIL923
PARTITION_OPTIONS
==================
Purpose: Specifies how table partitions should be created during an import operation.
Answer B is incorrect according to this reference: https://docs.oracle.com/database/121/SUTIL/GUID-C0122FE3-71EE-4E10-8F2A-03687227292C.htm#SUTIL201
COMPRESSION
============
COMPRESSION=[ALL | DATA_ONLY | METADATA_ONLY | NONE]
•ALL enables compression for the entire export operation. The ALL option requires that the Oracle Advanced Compression option be enabled.
•DATA_ONLY results in all data being written to the dump file in compressed format. The DATA_ONLY option requires that the Oracle Advanced Compression option be enabled.
•METADATA_ONLY results in all metadata being written to the dump file in compressed format. This is the default.
•NONE disables compression for the entire export operation
Answer D is incorrect according to this reference: https://docs.oracle.com/database/121/SUTIL/GUID-55EA54B5-BC13-48F1-AF14-485C16170274.htm#SUTIL928
REMAP_TABLE
============
Purpose: Allows you to rename tables during an import operation.