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
Explanation:
If the PLSQL_OPTIMIZER_LEVEL is set to 3 the compiler will automatically try and inline subprograms.
If the PLSQL_OPTIMIZER_LEVEL is set to 2 (the default) it will not automatically try and inline subprograms.
A,C
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/inline_pragma.htm#LNPLS01362
D) is correct as well, make use of inline on large help routine could save time, as well as result cache.