Multiple choice technology databases

What is the default behaviour of OUT parameter mode in PL/SQL

  1. By value

  2. By reference

  3. By type

  4. none of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
AI explanation

By default, PL/SQL passes OUT (and IN OUT) parameters "by value": the subprogram works on a local copy, and the value is copied back to the actual argument only if the subprogram completes normally without an unhandled exception. IN parameters, by contrast, are passed by reference (read-only). "By reference" for OUT parameters only happens if you explicitly add the NOCOPY compiler hint, which is an optimization, not the default. "By type" isn't a real PL/SQL parameter-passing mode.

Keep practicing — related questions