Multiple choice technology databases

what should be program type of a program that is of 'STORED PROCEDURE' ?

  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

For a stored procedure in DBMS_SCHEDULER, the program_type should be 'STORED_PROCEDURE'. PLSQL_BLOCK is for anonymous PL/SQL blocks, and EXECUTABLE is for external executables like shell scripts.