Multiple choice technology databases

Which two describe a stored procedure?

  1. A stored procedure is typically written in SQL.

  2. A stored procedure is a named PL/SQL block that can accept parameters.

  3. A stored procedure is a type of PL/SQL subprogram that performs an action.

  4. A stored procedure has three parts: the specification, the body, and the exception handler part.

  5. The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment.
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Option A is incorrect: stored procedures are written in PL/SQL (not SQL). Option B is correct: stored procedures are named PL/SQL blocks that accept parameters. Option C is correct: stored procedures are PL/SQL subprograms that perform actions. Option D is incorrect: procedures have specification and body, not three parts. Option E is incorrect: the executable section does not return values to the calling environment.

Keep practicing — related questions