Oracle Database: Program with PL/SQL — Question 64

Which PRAGMA statement may enable associated PL/SQL functions to run more efficiently when called from SQL?

Answer options

• A. PRAGMA SERIALLY_REUSABLE;
• B. PRAGMA UDF;
• C. PRAGMA INLINE (‘<function_name>’, ‘YES’);
• D. PRAGMA AUTONOMOUS_TRANSACTION;

Correct answer: B

Explanation

The correct answer is B, PRAGMA UDF, which is specifically designed to optimize user-defined functions for better execution when called from SQL. The other options, while they have their own purposes (e.g., managing transactions or function reuse), do not directly enhance the efficiency of PL/SQL functions in the same way as PRAGMA UDF.