Free 1Z0-148 Oracle Exam Dumps Questions Answers

Question No : 5

Refer to the Exhibit.

PL/SQL tracing in enabled in a user session using this command: EXEC DBMS_TRACE.SET_PLSQL_TRACE (DBMS_TRACE.TRACE_ENABLED_LINES)
The procedure is executed using this command: EXEC PRC_1 Examine the exhibit for the content of the PLSQL_TRACE_EVENTS table. Why is tracing excluded from the PLSQL_TRACE_EVENTS
table?

A. DBMS_TRACE.TRACE_ENABLED_LINES traces only exceptions in subprograms.
B. PRC_1 is not compiled with debugging information.
C. Tracing is not enabled with the TRACE_ENABLED_CALLS option.
D. PRC_1 is compiled with the default AUTHID DEFINER clause.
E. Tracing will be enabled only for the second execution of PRC_1.

Answer: B,E