Exam 1z0-082 topic 1 question 30 discussion

typo. B & C is correct answer.

B & C is correct. see the example which is done on 12c version B. You can reattach to it and monitor it C. It is paused and can be resumed

The correct answers are: B. You can reattach to it and monitor it D. It continues to run in the background Explanation: When you detach from the job using CTRL+C and then execute the STOP_JOB=IMMEDIATE command with yes confirmation: The job does not terminate immediately (contrary to option E) The job continues to run in the background (option D) You can reattach to the job and monitor its progress (option B) Data Pump Job Status: After detaching and stopping the job: Job status: RUNNING (in the background) Job can be reattached using ATTACH command

A - FALSE; the job can be attached and restarted at a later time with the START_JOB command. A KILL_JOB command performs non-reversible termination of the job. B - TRUE; see A C - TRUE; see A D - FALSE; it is completely stopped E - FALSE; it is stopped, but not terminated. A KILL_JOB command terminates the job. Release 19, Utilities; Part I Oracle Data Pump; 2.5.11 STOP_JOB; If the Data Pump control job table and dump file set are not disturbed when or after the STOP_JOB command is issued, then the job can be attached to and restarted at a later time with the START_JOB command. To perform an immediate shutdown, specify STOP_JOB=IMMEDIATE. A warning requiring confirmation will be issued. All attached clients, including the one issuing the STOP_JOB command, receive a warning that the job is being stopped by the current user and they will be detached. After all clients are detached, the process structure of the job is immediately run down. That is, the Data Pump control job process will not wait for the child processes to finish their current tasks.

A. You can no longer monitor it -- Semi-wrong, can be monitored if reattached. B. You can reattach to it and monitor it -- Correct, STOP_JOB can be reattached and monitored C. It is paused and can be resumed -- Correct, As per doc it can be resumed but some tasks may have to restarted. D. It continues to run in the background -- Wrong, The job is stopped E. It terminates -- Wrong, Terminates with KILL_JOB not STOP_JOB B and C seems to be the most correct https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-1A2BF459-680D-4D2B-B35F-9A3F4EE72530

Provided answer are corrects: https://docs.oracle.com/database/121/SUTIL/GUID-2BF78573-239C-4D56-8C40-B1F30F3E8609.htm#SUTIL953 To perform an immediate shutdown, specify STOP_JOB=IMMEDIATE. A warning requiring confirmation will be issued. All attached clients, including the one issuing the STOP_JOB command, receive a warning that the job is being stopped by the current user and they will be detached. After all clients are detached, the process structure of the job is immediately run down. That is, the master process will not wait for the worker processes to finish their current tasks. There is no risk of corruption or data loss when you specify STOP_JOB=IMMEDIATE. However, some tasks that were incomplete at the time of shutdown may have to be redone at restart time.

I choose BC

I think it is AE, the STOP_JOB will effectively stop the export. It is resummable but the question asks what happens when the STOP_JOB=IMMEDIATE option.

B,C is correct

"If the master table and dump file set are not disturbed when or after the STOP_JOB command is issued, then the job can be attached to and restarted at a later time with the START_JOB command." https://docs.oracle.com/database/121/SUTIL/GUID-2BF78573-239C-4D56-8C40-B1F30F3E8609.htm#SUTIL953

i choose B and C for the correct answer

Export> start_job

A is wrong because you can still be monitor & see the status of Job via attach= correct is B & C.

AC B - it can be reattached, but it is no longer running, so it can’t be monitored in that meaning D - wrong E - KILL_JOB does that not STOP_JOB

A & B is correct answer On 12c Export>stop_job=immediate; Export> start_job . . exported "SSSSMS"."ABM_FACILITY_PREF_DET" 0 KB 0 rows Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at Sat Jul 18 18:0 <<<<<<<<<<<<<this is error because stop_job=immediate; Job SYS_EXPORT_FULL_01 has been reopened at Sat Jul 18 18:05:10 2020 ORA-39012: Client detached before the job started. Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at Sat Jul 18 18:07:39 2020 elapsed 0 00:02:30 Job SYS_EXPORT_FULL_01 håas been reopened at Sat Jul 18 18:07:43 2020 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<see job are started again Export> start_job Restarting "SYSTEM"."SYS_EXPORT_FULL_01": "system/********@aauat" directory=IMPDP1 dumpfile=aauat_full_%U..dmp logfile=aauat_full_..log compression=all full=y parallel=4 . . exported "SSSSMS"."AWTM_STANDARD_XML" 0 KB 0 rows