Multiple choice technology databases

Choose correct statement below

  1. When a parameter is passed as an IN variable it is passed by reference

  2. When variables are passed in OUT or INOUT mode it is pass by value

  3. The NOCOPY clause tells to PL/SQL engine to pass the variable by reference

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

IN parameters are passed by reference (a pointer to the value). OUT and IN OUT parameters are passed by value by default. The NOCOPY compiler hint tells PL/SQL to pass OUT and IN OUT parameters by reference instead of value for performance. All three statements about parameter passing modes are correct.

Keep practicing — related questions