ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

1 / 68

Question 1:

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