Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that
apply.)
A.
ENABLE
B.
ENABLE_PROGRAM
C.
VALIDATE_PROGRAM
D.
SET_ATTRIBUTE
E.
SET_ENABLED
Explanation:
Refer to here.
ENABLE Procedure, Enables a program, job, chain, window, or window group
SET_ATTRIBUTE Procedure, Changes an attribute of a job, schedule, or other Scheduler
object
A is correct, D exists, but unsure if it will enable programs:
https://docs.oracle.com/cd/B13789_01/appdev.101/b10802/d_sched.htm#1012304
ENABLE Procedure
Enables a program, job, window, or window group
SET_ATTRIBUTE Procedure
Changes an attribute of a Scheduler object
All other options do not exist.
There exists an Job Object Type Attribute “Enabled” in this table:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sched.htm#BABDFJFB