Oracle 11G OCP 1Z0-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.

答案：（A、B、C）

解析：

DBMS_SCHEDULE.CREATE_JOB

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1298711/，如需轉載，請註明出處，否則將追究法律責任。