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’)
The program must be already enabled when the lightweight job is created, and the program type must be either ‘PLSQL_BLOCK’ or ‘STORED_PROCEDURE’
Kelvin is correct, see
http://oracle.su/docs/11g/server.112/e10595/schedover003.htm#CHDECJDB
A and D are correct:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedover004.htm#BGBJGHBH
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’