Load and unload data
These questions based on 1Z0-045 Oracle Database 10g DBA New Features for Oracle8i OCPs.
Objective: Load and unload data.
Sub-objective: Explain Data Pump architecture.
Single answer, multiple choice
Which interactive command is used to terminate a Data Pump job so it cannot be restarted again?
- You cannot stop a Data Pump job.
The KILL_JOB interactive command is used to terminate a Data Pump job so it cannot be restarted later.
The STOP_JOB interactive command can be used to stop a Data Pump job. The stopped job can be restarted later.
The TERMINATE_JOB interactive command is an invalid interactive command. This command does not exist in Oracle.
The option stating you cannot stop a Data Pump job is incorrect. A Data Pump job can be stopped using the STOP_JOB and KILL_JOB interactive commands.
1. Oracle University - Oracle Database 10g: New Features for Administrators - Load and Unload Data
2. Oracle University - Oracle Database 10g: New Features for Administrators - Data Pump, SQL*Loader, and External Tables
3. Oracle Database Utilities
10g Release 2 (10.2)
Part Number B14215-01
Chapter: 2 Data Pump Export