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.
Explanation:
Data Pump: Enables the high-speed transfer of data from one database to another (For example,
you may want to export a table and import it into another database.)
Oracle Data Pump: Benefits
The EXCLUDE, INCLUDE, and CONTENT parameters are used for fine-grained object and data
selection.
You can specify die database version for objects to be moved (using the VERSION parameter) to
create a dump file set that is compatible with a previous release of the Oracle database that
supports Data Pump.
You can use the PARALLEL parameter to specify the maximum number of threads of active
execution servers operating on behalf of the export job.
You can estimate how much space an export job would consume (without actually performing the
export) by using the ESTIMATE_ONLY parameter.
Network mode enables you to export from a remote database directly to a dump file set. This can
be done by using a database link to the source system.
During import, you can change the target data file name, scheme, and tablespace.
In addition you can specify a percentage of data to be sampled and unloaded from the source
database when performing a Data Pump export. This can be done by specifying the SAMPLE
parameter.
You can use the COMPRESSION parameter to indicate whether the metadata should be
compressed in the export dump file so that it consumes less disk space. If you compress the
metadata, it is automatically uncompressed during import.