The user SYS creates a job by using the following command:
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
B is wrong … the job is automatically disable, not droped.
Sorry… B is correct:
DBMS_SCHEDULER.CREATE_JOB (
job_name IN VARCHAR2,
job_type IN VARCHAR2,
job_action IN VARCHAR2,
number_of_arguments IN PLS_INTEGER DEFAULT 0,
start_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
repeat_interval IN VARCHAR2 DEFAULT NULL,
end_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
job_class IN VARCHAR2 DEFAULT ‘DEFAULT_JOB_CLASS’,
enabled IN BOOLEAN DEFAULT FALSE,
auto_drop IN BOOLEAN DEFAULT TRUE,
comments IN VARCHAR2 DEFAULT NULL);