Which of the following are valid program types for a lightweight job? (Choose all that apply.)
A.
PLSQL_BLOCK
B.
EXECUTABLE
C.
JAVA_STORED_PROCEDURE
D.
STORED_PROCEDURE
E.
EXTERNAL
Explanation:
Job_type
Job action type (‘PLSQL_BLOCK’, ‘STORED_PROCEDURE’, ‘EXECUTABLE’, or ‘CHAIN’)
A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either ‘PLSQL_BLOCK’ or ‘STORED_PROCEDURE’. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job.