Oracle
1Z0-146 · Question #134
Which three statements are true about hierarchical profiling? (Choose three.)
The correct answer is A. It provides function-level summaries. C. It is useful for understanding the structure and control flow of complex programs. D. It can be used to identify hotspots and tuning opportunities in PL/SQL applications. See the full explanation below for the reasoning.
Question
Which three statements are true about hierarchical profiling? (Choose three.)
Options
- AIt provides function-level summaries.
- BIt produces an aggregated report of the SQL and PL/SQL execution times.
- CIt is useful for understanding the structure and control flow of complex programs.
- DIt can be used to identify hotspots and tuning opportunities in PL/SQL applications.
- EIt generates trace information for PL/SQL programs in the PLSQL_TRACE_EVENTS table.
How the community answered
(23 responses)- A74% (17)
- B9% (2)
- E17% (4)
Community Discussion
No community discussion yet for this question.