Which DBMS_SCHEDULER procedure(s) can be used to alter …

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

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

Explanation:
SET_ATTRIBUTE_NULL Procedure, Changes an attribute of an object to NULL
SET_ATTRIBUTE Procedure, Changes an attribute of a job, schedule, or other Scheduler object
There is NO such “ALTER_JOB”, “ALTER_JOB_PARAMETERS” and “ALTER” procedure available.



Leave a Reply 0

Your email address will not be published. Required fields are marked *