651.The user SYS creates a job by using the following command:
BEGIN
DBMS_SCHEDULED.CREATE_JOB( job_name ==> 'update_sales',
job_type ==> 'STOPED-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
Answer: BC
默认情况下，创建的JOB使用AUTO_DROP属性的默认值TRUE，表示JOB到期后自动删除。 B正确
默认情况下，创建的JOB默认是DISABLE。 A错误
SYS用户创建的JOB，运行时带有SYS权限。 C正确
JOB运行时不再带有创建时的全球化环境。 D错误
BEGIN
DBMS_SCHEDULED.CREATE_JOB( job_name ==> 'update_sales',
job_type ==> 'STOPED-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
Answer: BC
默认情况下，创建的JOB使用AUTO_DROP属性的默认值TRUE，表示JOB到期后自动删除。 B正确
默认情况下，创建的JOB默认是DISABLE。 A错误
SYS用户创建的JOB，运行时带有SYS权限。 C正确
JOB运行时不再带有创建时的全球化环境。 D错误
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2120592/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q646
下一篇：
1Z0-053 V13.02 Q657
请登录后发表评论
登录
全部评论
