OCP 12 Load and Unload Data

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

Which parameter of the Data Pump Import utility is used to alter the object creation data definition language (DDL) commands for specific database objects?

Which entity of the Data Pump job controls the entire Data Pump job?

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?

Which parameter of the Data Pump Import utility loads all the objects from the source schema into the target schema?

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?

Which entity of a Data Pump job stores information about the Data Pump Export and Data Pump Import utilities?

What are the five different modes for Data Pump Export and Data Pump Import operations?

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?

Which parameter of the Data Pump Export utility enables you to export either data or metadata or both data and metadata?

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?

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?