Oracle OCP 1Z0 053 Q453(STOP_JOB)

abstractcyj發表於2016-04-06
453.What is the danger associated with stopping a running job by using the STOP_JOB procedure?
A. The job will need to be reenabled before it will execute again.
B. The job may hold locks on objects referenced within it.
C. All jobs within the job group will also be stopped.
D. The job may leave data in an inconsistent state.
E. There is no danger in using the STOP_JOB procedure.
Answer: D

文件: http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12399

stop_job會中斷當前的事務並回滾。

Caution:
When a job is stopped, only the current transaction is rolled back. This can cause data inconsistency.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2076011/,如需轉載,請註明出處,否則將追究法律責任。

相關文章