Question 1) Test Yourself on Oracle Database 10g

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: Transport Tablespaces Across Different Platforms

Multiple Answer Multiple Choice

 

In which two scenarios of a data pump operation is the master table dropped? (Choose two.)

 

A. if the job terminates unconditionally
B. if the job is killed using the KILL_JOB command
C. upon successful completion of the data pump job
D. if the job is stopped using the STOP_JOB command
E. The master table can never be dropped

 

Answer:
B. if the job is killed using the KILL_JOB command
C. upon successful completion of the data pump job

 

Tutorial:
The master table is dropped in only two scenarios, if the job is killed using the KILL_JOB command or if the data pump job completes successfully. If the job is killed using the KILL_JOB command, the master table gets dropped and the job cannot be restarted again.

 

The master table does not get dropped if the job terminates unexpectedly. The master table is retained if the data pump job terminates unconditionally. The data pump job can be restarted later using the information stored in the master table.

 

The master table does not get dropped if the job is stopped using the STOP_JOB command. The master table is retained, and the information stored in the master table can be used to restart the data pump job.

 

The option stating the master table can never be dropped is incorrect because the master table can be dropped.

 

Reference:

 

1. Oracle University – Oracle Database 10g: New Features for Administrators – Load and Unload

 

2. OTN – http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10825/dp_overview.htm#i1010266

 

These questions are derived from the Self Test Software Practice Test for Oracle exam #1Z0-040: Oracle Database 10g: New Features for Administrators.

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: