Oracle Database: Program with PL/SQL — Question 62

Which two statements about the PL/SQL hierarchical profiler are true?

Answer options

• A. Access it using the DBMS_PROFILER package.
• B. Access it using the DBMS_HPROF package.
• C. Profiler data is recorded in tables and published in HTML reports.
• D. It is only accessible after a grant of the CREATE PROFILE privilege.
• E. It helps you identify subprograms that are causing bottlenecks in application performance.

Correct answer: B, E

Explanation

The correct answers are B and E. The DBMS_HPROF package is specifically used to access the PL/SQL hierarchical profiler, while option E accurately describes its purpose in identifying performance bottlenecks. Options A and D are incorrect as they refer to the wrong packages and privileges, and option C does not apply to the hierarchical profiler's data handling.