（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.

答案：（A、B、C）

解析：

DBMS_SCHEDULE.CREATE_JOB

ITPub博客

Oracle 11G OCP 1Z0-053 455