The user SYS creates a job by using the following command:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => ‘update_sales’,
job_type => ‘STORED-PROCEDURE’,
job_action => ‘OPS.SALES_PKG.UPDATE_SALES_SUMMARY’,
start_date => ’28-DEC-07 07.00.00 PM Australia/Sydney’,
repeat_interval => ‘FREQ=DAILY; INTERVAL=2’,
end_date => ’20-JAN-08 07.00.00 PM Australia/Sydney’,
comments => ‘New sales job’);
END;
/
Which two statements are true about the job that was created by the preceding command?
(Choose two.)
A.
The job is enabled by default after creation
B.
The job is automatically dropped after the end date
C.
The job executes with the privileges of the user SYS
D.
The globalization environment that exists at the time of the job creation prevails at the job
runs
Explanation:
By default, jobs are created with auto_drop set to TRUE.
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.