Multiple choice technology databases

To be callable from SQL expressions, a user-defined function must: 1. Be a stored function 2. Accept only IN parameters 3. Accept only valid SQL data types, not PL/SQL specific types, as parameters 4. Return data types that are valid SQL data types, not PL/SQL specific types

  1. All are true

  2. 1, 2 and 4 are true

  3. 1 and 2 alone true

  4. 2 and 3 alone are ture
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

All four statements are correct requirements for functions called from SQL. The function must be stored (not anonymous), accept only IN parameters (OUT/IN OUT not permitted in SQL context), and use only SQL data types for both parameters and return values (PL/SQL types like BOOLEAN or RECORD are not allowed in SQL).

Keep practicing — related questions