nerdexam
Oracle

1Z0-144 · Question #43

Which two statements are correct about the usage of parameters in functions? (Choose two.)

The correct answer is B. Functions called in SQL statements cannot have out or in out mode parameters. D. Functions having in, out, or in out parameters can be called In PL/SQL procedures and. See the full explanation below for the reasoning.

Question

Which two statements are correct about the usage of parameters in functions? (Choose two.)

Options

  • AFunctions can have only in mode parameters.
  • BFunctions called in SQL statements cannot have out or in out mode parameters.
  • CFunctions having in, out, or in out parameters can be called only in named PL/SQL subprograms
  • DFunctions having in, out, or in out parameters can be called In PL/SQL procedures and

How the community answered

(63 responses)
  • A
    11% (7)
  • B
    71% (45)
  • C
    17% (11)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice