Home » Oracle » 1z0-052 v.2 » Which two statements are true regarding the Oracle Data Pump export and import operations?
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.
Correct Answer: BC
Explanation/Reference:
• 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.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
