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?
ORACLE_LOADER
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?
KILL_JOB
Which interactive command is used to temporarily stop a Data Pump job?
STOP_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?
DBA_DATAPUMP_JOBS
Which dictionary view displays the progress of a Data Pump job?
V$SESSION_LONGOPS
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?