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     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 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.
If no value for end_date is specified, the job will repeat forever unless max_runs or max_failures is set, in which case the job stops when either value is reached.
The value for end_date must be after the value for start_date. If it is not, an error is generated when the job is enabled.

auto_drop


This flag, if TRUE, causes a job to be automatically dropped after it has completed or has been disabled. A job is considered completed if:
Its end date (or its schedule's end date) has passed
It has run max_runs number of times. max_runs must be set with SET_ATTRIBUTE.
It is not a repeating job and has run once
A job is disabled when it has failed max_failures times. max_failures is also set with SET_ATTRIBUTE.
If this flag is set to FALSE, the jobs are not dropped and their metadata is kept until the job is explicitly dropped with the DROP_JOB procedure.
By default, jobs are created with auto_drop set to TRUE.

官方文档：http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_sched.htm#i1011092