Multiple choice technology databases

What is true about stored procedures?

  1. A stored procedure uses the DECLARE keyword in the procedure specification to declare formal parameters

  2. A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification

  3. A stored procedure must have at least one executable statement in the procedure body.

  4. A stored procedure uses the DECLARE keyword in the procedure body to declare formal
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A stored procedure body must contain at least one executable statement (such as NULL; if no action is needed). It does not require parameter declarations, does not use the DECLARE keyword in the parameter block, and uses IS or AS instead of DECLARE in the body block.

Keep practicing — related questions