Oracle OCP IZ0-053 Q651(Scheduler Job)

651.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
Answer: BC

驗證：
BEGIN
  dbms_scheduler.create_job(job_name        => 'OCP651_Verify',
                            job_type        => 'STORED_PROCEDURE',
                            job_action      => 'scott.sp_test',
                            start_date      => to_date('20150309 00:00:00',
                                                       'yyyymmdd hh24:mi:ss'),
                            repeat_interval =>'FREQ=DAILY;INTERVAL=2',
                            end_date        => to_date('20150320 00:00:00',
                                                       'yyyymmdd hh24:mi:ss'),
                            comments        => 'Testing');
END;

SQL> SELECT job_name, owner, j.auto_drop, j.enabled
  2    FROM dba_scheduler_jobs j
  3   WHERE job_name = 'OCP651_VERIFY';


JOB_NAME                       OWNER                          AUTO_ ENABL
------------------------------ ------------------------------ ----- -----
OCP651_VERIFY                  SYS                            TRUE  FALSE

可以看出，JOB建立時預設是AUTO DROP, ENABLED=FALSE

參考：http://blog.csdn.net/rlhua/article/details/16105705

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2054971/，如需轉載，請註明出處，否則將追究法律責任。