Oracle Database: Program with PL/SQL — Question 60

Which three statements are correct with reference to intra unit inlining?

Answer options

• A. Inlining will always decrease the size of a unit.
• B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
• C. You cannot inline an external subroutine.
• D. Programs that make use of smaller helper subroutines are good candidates for inlining.
• E. Pragmas apply only to calls in the next statement following the pragma.
• F. You cannot inline local subroutines.

Correct answer: C, D, E

Explanation

The correct statements C, D, and E highlight the limitations and appropriate use cases for intra unit inlining. C is correct because external subroutines cannot be inlined, D is right since smaller helper subroutines are ideal for this process, and E is accurate as pragmas only affect the immediate next statement. Options A, B, and F are incorrect as they misrepresent the rules and implications of inlining.