Which two statements are true about the job that was created by the preceding command?

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.)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *