OCP 12 Load and Unload Data

Card Set Information

Author:
Tralala
ID:
213631
Filename:
OCP 12 Load and Unload Data
Updated:
2013-04-22 09:53:16
Tags:
OCP 12 Load Unload Data
Folders:

Description:
OCP 12 Load and Unload Data
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. 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
  2. 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
  3. Which entity of the Data Pump job controls the entire Data Pump job?
    The master process
  4. Which interactive command is used to stop a Data Pump job so that the job cannot be restarted?
    KILL_JOB
  5. Which interactive command is used to temporarily stop a Data Pump job?
    STOP_JOB
  6. 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
  7. Which parameter of the Data Pump Import utility loads all the objects from the source schema into the target schema?
    The REMAP_SCHEMA parameter
  8. 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
  9. Which entity of a Data Pump job stores information about the Data Pump Export and Data Pump Import utilities?
    The master table
  10. What are the five different modes for Data Pump Export and Data Pump Import operations?
    full, table, schema, tablespace, and transportable tablespace
  11. 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
  12. Which parameter of the Data Pump Export utility enables you to export either data or metadata or both data and metadata?
    The CONTENT parameter
  13. 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
  14. Which dictionary view displays all the Data Pump jobs executing in a database?
    DBA_DATAPUMP_JOBS
  15. Which dictionary view displays the progress of a Data Pump job?
    V$SESSION_LONGOPS
  16. 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