122 The user SYS creates a job by using the following command: BEGIN DBMS_SCHEDULER.CREATE_JOB ( job

EVISWANG

于 2015-11-28 10:00:15 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： OCP 053

本文链接：https://blog.youkuaiyun.com/EVISWANG/article/details/50081791

OCP 053 专栏收录该内容

86 篇文章

订阅专栏

本文详细介绍了如何利用DBMS_SCHEDULER在数据库中创建一个定时任务，包括任务的基本属性如名称、类型、操作、运行时间间隔以及执行权限等。重点阐述了任务的创建过程及关键参数设置。

122
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

Correct Answer: BC
Section: (none)