nerdexam
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)
  • A
    4% (1)
  • B
    78% (18)
  • D
    13% (3)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-147 Practice