Question 2) New Features for Oracle8i OCPs

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Objective: Load and Unload Data
SubObjective: Explain Data Pump architecture

 

Single Answer Multiple Choice

 

Which interactive command is used to terminate a data pump job so that it cannot be restarted again?

 

A. STOP_JOB
B. KILL_JOB
C. TERMINATE_JOB
D. You cannot stop a data pump job.

 

Answer:
B. KILL_JOB

 

Tutorial:
The KILL_JOB interactive command is used to terminate a data pump job so that 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.

 

Reference:
1. Oracle University – Oracle Database 10g: New Features for Administrators – Load and Unload Data
D17079GC10
Edition 1.0
February 2004
D39100

 

2. Oracle University – Oracle Database 10g: New Features for Administrators – Data Pump, SQL*Loader, and External Tables
D17079GC21
Edition 2.1
October 2005
D22243

 

3. Oracle Database Utilities
10g Release 2 (10.2)
Part Number B14215-01
Chapter: 2 Data Pump Export
Topic: KILL_JOB
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#sthref204

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: