Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)
A.
Only local subroutines can be inlined.
B.
Inlining always reduces the execution time for 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.
AC
A. true
Inlining replaces a subprogram call (to a subprogram in the same program unit) with a copy of the called subprogram.
C. true
If PLSQL_OPTIMIZE_LEVEL=2, YES specifies that the subprogram call is to be inlined.
If PLSQL_OPTIMIZE_LEVEL=3, YES specifies that the subprogram call has a high priority for inlining.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/inline_pragma.htm#LNPLS01362
A, C