📚 Practice Mode

Database Fundamentals: Oracle, PL/SQL, and SQL

Learn at your own pace with hints and detailed explanations

1 / 17
Multiple Answers

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.
Change Mode