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/
,如需转载,请注明出处,否则将追究法律责任。