Which two describe a stored procedure? (Choose two)
A.
A stored procedure is typically written in SQL.
B.
A stored procedure is a named PL/SQL block that can accept parameters.
C.
A stored procedure is a type of PL/SQL subprogram that performs an action.
D.
A stored procedure has three parts: the specification, the body, and the exception handler part.
E.
The executable section of a stored procedure contains statements that assigns values, control
execution, and return values to the calling environment.
Explanation:
A procedure is a named PL/SQL block that can accept parameters (sometimes referred to as
arguments), and be invoked. Generally speaking, you use a procedure to perform an action. A
procedure has a header, a declaration section, an executable section, and an optional exceptionhandling section.
A procedure can be compiled and stored in the database as a schema object.
Procedures promote reusability and maintainability. When validated, they can be used in any
number of applications. If the requirements change, only the procedure needs to be updated.