Oracle
1Z0-147 · Question #39
Which two describe a stored procedure? (Choose two.)
The correct answer is B. B. A stored procedure is a named PL/SQL block that can accept parameters. C. C. A stored procedure is a type of PL/SQL subprogram that performs an action. See the full explanation below for the reasoning.
Question
Which two describe a stored procedure? (Choose two.)
Options
- AA. A stored procedure is typically written in SQL.
- BB. A stored procedure is a named PL/SQL block that can accept parameters.
- CC. A stored procedure is a type of PL/SQL subprogram that performs an action.
- DD. A stored procedure has three parts: the specification, the body, and the exception handler part .
- EE. The executable section of a stored procedure contains statements that assign values, control execution, and return values to the calling environment.
How the community answered
(23 responses)- A4% (1)
- B78% (18)
- D13% (3)
- E4% (1)
Community Discussion
No community discussion yet for this question.