Multiple choice technology databases

Which statements are true about inlining of PL/SQL subprograms?

  1. Only local subroutins can be inlined

  2. Inlining always reduces the execution time for the PL/SQL program unit

  3. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2

  4. the PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining
Reveal answer Fill a bubble to check yourself
A,C Correct answer

Keep practicing — related questions