Multiple choice technology databases

A function must return zero or more values to its calling environment, whereas a procedure returns a value to the calling environment.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In PL/SQL, a function must return exactly one value, not zero or more. A procedure does not return a value to its calling environment (it can have OUT parameters, but that's different from a return value). The statement reverses the correct definitions, making it false.

AI explanation

The statement has it backwards: a function is defined to always return exactly one value to its caller, while a procedure (or subprogram) typically returns zero values (or produces side effects) rather than a required return value. Since the statement swaps these roles, it is false as written.

Keep practicing — related questions