OCP 12 Load and Unload Data
Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
If you use the AS subquery clause to unload data and attempt to use the CREATE TABLE statement to create an external table, which access driver CANNOT be specified in the TYPE clause of the CREATE
- TABLE statement?
Which parameter of the Data Pump Import utility is used to alter the object creation data definition language (DDL) commands for specific database objects?
The TRANSFORM parameter
Which entity of the Data Pump job controls the entire Data Pump job?
The master process
Which interactive command is used to stop a Data Pump job so that the job cannot be restarted?
Which interactive command is used to temporarily stop a Data Pump job?
Which parameter of the Data Pump Import utility should you use to change the name of the source data file to the target data file in the SQL statements in which the source data file is referenced?
The REMAP_DATAFILE parameter
Which parameter of the Data Pump Import utility loads all the objects from the source schema into the target schema?
The REMAP_SCHEMA parameter
Which four parameters of the Data Pump Import utility can you use to remap storage between tablespaces or to redefine the owner of a particular set of objects?
TRANSFORM, REMAP_SCHEMA, REMAP_DATAFILE, and REMAP_TABLESPACE parameters
Which entity of a Data Pump job stores information about the Data Pump Export and Data Pump Import utilities?
The master table
What are the five different modes for Data Pump Export and Data Pump Import operations?
full, table, schema, tablespace, and transportable tablespace
Which value should you assign to the CONTENT parameter of the Data Pump Export utility to export both the data information and the metadata information?
The ALL value
Which parameter of the Data Pump Export utility enables you to export either data or metadata or both data and metadata?
The CONTENT parameter
Which parameter of the Data Pump Export utility specifies the location to which an export transaction can write the dump file set and the log file?
The DIRECTORY parameter
Which dictionary view displays all the Data Pump jobs executing in a database?
Which dictionary view displays the progress of a Data Pump job?
What happens to the master table if the Data Pump job is executed successfully or if the Data Pump job is stopped by using the KILL_JOB command?
The master table is dropped
What would you like to do?
Home > Flashcards > Print Preview