Oracle Database 11g: Advanced PL/SQL — Question 3

Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)

Answer options

• A. Only local subroutines can be inlined
• B. Inlining always reduces the execution time of a PL/SQL program unit
• C. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2
• D. The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining

Correct answer: A, C

Explanation

Option A is correct because only local subroutines can be inlined, as they are within the same scope. Option C is also correct because the PLSQL_OPTIMIZE_LEVEL must be at least 2 for inlining to occur. Options B and D are incorrect because inlining does not always guarantee reduced execution time, and not all programs with large subroutines are suited for inlining.