Which two statements are true regarding the Oracle Data Pump export and import operations?
(Choose two.)
A.
You cannot export data from a remote database.
B.
You can rename tables during an import operation.
C.
You can overwrite existing dump files during an export operation.
D.
You can compress the data during export but not the metadata because it is not supported.
Data Pump Components
Oracle Data Pump is made up of three distinct parts:
The command-line clients, expdp and impdp
The DBMS_DATAPUMP PL/SQL package (also known as the Data Pump API)
The DBMS_DATAPUMP and DBMS_METADATA PL/SQL packages can be used independently of the Data Pump clients.
The DBMS_METADATA PL/SQL package (also known as the Metadata API)
The Data Pump clients, expdp and impdp, invoke the Data Pump Export utility and Data Pump Import utility, respectively.
The expdp and impdp clients use the procedures provided in the DBMS_DATAPUMP PL/SQL package to execute export and import commands, using the parameters entered at the command line. These parameters enable the exporting and importing of data and metadata for a complete database or for subsets of a database.
When metadata is moved, Data Pump uses functionality provided by the DBMS_METADATA PL/SQL package. The DBMS_METADATA package provides a centralized facility for the extraction, manipulation, and re-creation of dictionary metadata.
A. You can export data from a remote database.
B. REMAP_TABLE – Can rename tables during an import operation with the transportable method.
C. (ORACLE DOC) – overwrite existing dump files during an export operation. See REUSE_DUMPFILES.
D. optionally encrypt data and metadata during export, only the encrypted data, only metadata is encrypted, not only the encrypted data or the encrypted columns.