455th questions, 053455

455th questions, 053455

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. Afterend_date, Ifauto_dropIsTRUE, The job is dropped. Ifauto_dropIsFALSE, The job is disabled andSTATEOf the job is setCOMPLETED.

From this we can see that AB is correct, the job does not have the state attribute, and there is no cascade attribute. Therefore, CD is incorrect, and E is correct.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.