ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 Q455(Schedule Job-End_DATE)

Oracle OCP 1Z0 Q455(Schedule Job-End_DATE)

原创 Oracle 作者:abstractcyj 时间:2016-04-02 14:29:36 0 删除 编辑
455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?
(Choose all that apply.)
A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.
B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.
C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE.
D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE.
E. The STATE column of the job table will be set to COMPLETED for the job.
Answer: ABE


参考:http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_sched.htm#i1000363
end_date
This attribute specifies the date after which the job will expire and will no longer be executed. When end_date is reached, the job is disabled. The STATE of the job will be set to COMPLETED, and the enabled flag will be set to FALSE.

END_DATE属性设置之后,在这个时间点之后,JOB会过期,并且再也不会允许。
当END_DATE到达之后, JOB会被disable, STATE会被置为COMPLETED, ENABLED被置为FALSE

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2074171/ ,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091649