Oracle Advanced PL/SQL Developer Professional Guide

Chapter 11, Profiling and Tracing PL/SQL Code

Question No.	Answer	Explanation
1	b	The Analyzer component interprets the raw profiler data and loads into the database tables.
2	b	The plshprof is a command-line utility to generate HTML reports from raw profiler output.
3	d	The PLSQL_DEBUG parameter has been deprecated starting from Oracle 11g.
4	c	The $ORACLE_HOME\rdbms\admin\tracetab.sql script creates the trace log tables—PLSQL_TRACE_RUNS and PLSQL_TRACE_EVENTS.
5	c and d	The trace control levels cannot be used in combination with the other trace levels.
6	a and b	The plshprof utility is a command-line tool to convert raw profiler data into HTML reports.
7	c	The Analyzer component can trace multiple subprograms profiled ...