053第455题

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

end_date

This attribute specifies the date and time after which the job expires and is no longer run. After the end_date, if auto_drop is TRUE, the job is dropped. If auto_drop is FALSE, the job is disabled and the STATE of the job is set to COMPLETED.

由此看见AB正确，job没有state属性，也没有cascade属性，所以CD不正确，E正确。