OCP-1Z0-053-V13.02-443题

443.Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

A. SET_ATTRIBUTE_NULL

B. ALTER_JOB

C. ALTER_JOB_PARAMETERS

D. ALTER

E. SET_ATTRIBUTE

Answer: AE

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72402

题问：哪一个DBMS_SCHEDULER包的存储过程可以用来改变现有存在的作业？

SET_ATTRIBUTE Procedure	Changes an attribute of a job, schedule, or other Scheduler object
SET_ATTRIBUTE_NULL Procedure	Changes an attribute of an object to NULL

SET_ATTRIBUTE Procedure

This procedure modifies an attribute of a Scheduler object. It is overloaded to accept values of various types. To set an attribute to NULL, use theSET_ATTRIBUTE_NULL procedure. The attributes that can be set depend on the object being altered. All object attributes can be changed, except the object name.

 

SET_ATTRIBUTE_NULL Procedure

This procedure sets an attribute of an object to NULL. The attributes that can be set depend on the object being altered. If the object is enabled, it is disabled before being altered and reenabled afterward. If the object cannot be reenabled, an error is generated and the object is left in a disabled state.