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

technology databases

  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

Show answer
Correct Option: A,C

Find more quizzes: