READ Free Dumps For Oracle- 1z0-146
| Question ID 20554 | Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.) |
| Option A | Only local subroutines can be inlined |
| Option B | Inlining always reduces the execution time of a PL/SQL program unit |
| Option C | PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2 |
| Option D | The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining |
| Correct Answer | A,C |
| Question ID 20555 | Which three statements are true about hierarchical profiling? (Choose three.) |
| Option A | It reduces function-level summaries |
| Option B | It produces an aggregated report of the SQL and PL/SQL execution times |
| Option C | It is useful for understanding the structure and control flow of complex programs |
| Option D | It can be used to identify hotspots and tuning opportunities in PL/SQL applications |
| Correct Answer | A,C,D |