nerdexam
Oracle

1Z0-144 · Question #58

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

The correct answer is A. A procedure can contain a return statement without a value. D. A function can contain zero or more parameters that are transferred from the calling environment. See the full explanation below for the reasoning.

Question

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

Options

  • AA procedure can contain a return statement without a value.
  • BA function can return multiple values using a single return clause,
  • CA procedure can be executed as part of a SQL expression or as a PL/SQL statement,
  • DA function can contain zero or more parameters that are transferred from the calling environment.

How the community answered

(49 responses)
  • A
    86% (42)
  • B
    10% (5)
  • C
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice