Multiple choice technology databases

A user invoking a User Defined Function (UDF) requires which DB2 Privilege?

  1. Call

  2. Usage

  3. Execute

  4. Reference

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To invoke a User Defined Function, a user needs EXECUTE privilege on the function. CALL is used for invoking stored procedures in some database systems. USAGE is typically for domains, sequences, or types. REFERENCES is for foreign key constraints. EXECUTE is the correct privilege for UDFs in DB2.