ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q453(STOP_JOB)

Oracle OCP 1Z0 053 Q453(STOP_JOB)

原创 Oracle 作者:abstractcyj 时间:2016-04-06 11:14:40 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    834237