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

The STORED_PROCEDURE program type is specifically used for programs that execute stored procedures. PLSQL_BLOCK is for anonymous PL/SQL blocks, and EXECUTABLE is for external operating system commands or scripts. STORED_PROCEDURE_EXECUTABLE and STORED_EXECUTABLE are not valid program types.

Keep practicing — related questions