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.
Explanation:
auto_drop, If TRUE (the default), indicates that the job should be dropped once completed.
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.If no value for end_date is specified, the job repeats 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.
The aswer is A, B, E.
When a job exceeds its end date, it will be dropped only if the AUTO_DROP attribute
is set to TRUE. Otherwise, it will be disabled. In either case, the STATE column will be set to COMPLETED in the job table. A job object does not possess a CASCADE attribute or a STATE
attribute.
I have tried.
Answer ABC is correct.
B cannot be correct because …
it says …
The job will ONLY be disabled if the value of the AUTO_DROP attribute is FALSE.
However as the explanation says ….
If auto_drop is FALSE, the job is disabled and the STATE of the job is set to COMPLETED.
E is actually correct (at least according to some non official sources)
I found this question in a book I have and it gives the following answer to this question.
“Correct answer is A, B, E. When a job exceeds its end date, it will be dropped only if the AUTO_DROP attribute is set to TRUE. Otherwise, it will be disabled. In either case, the STATE column will be set to COMPLETED in the job table. A job object does not possess a CASCADE attribute or a STATE attribute.”
I did some research and I have have seen this text in several books and blogs etc but I have not found it in any official documentation, hmmmmmmmmmmmmm ……..what to do????
I am refering to the statement …
“In either case, the STATE column will be set to COMPLETED in the job table.”