ITPub博客

首页 > 数据库 > Oracle > Oracle OCP IZ0-053 Q651(Scheduler Job)

Oracle OCP IZ0-053 Q651(Scheduler Job)

原创 Oracle 作者:abstractcyj 时间:2016-03-10 14:29:02 0 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2054971/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091644