The following command is executed to start tracing in a user session: SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS); Which statement is true about the effect of the…

The correct answer is D. It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed. Profiling large applications may produce a large volume of data. You can control the volume of data collected by enabling specific program units for trace data You can enable a program unit by compiling it debug. This can be done in one of two ways: ALTER SESSION SET…

Debugging and Profiling PL/SQL Code

Question

The following command is executed to start tracing in a user session:

SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS); Which statement is true about the effect of the command?

Options

AIt allows tracing of exceptions raised by all subprograms executed in the session.
BIt allows tracing of user-defined exceptions raised by all subprograms executed in the session.
CIt allows tracing of system-defined exceptions raised by all subprograms executed in the session.
DIt allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed

How the community answered

(23 responses)

A
4% (1)
B
4% (1)
C
13% (3)
D
78% (18)

Explanation

Profiling large applications may produce a large volume of data. You can control the volume of data collected by enabling specific program units for trace data You can enable a program unit by compiling it debug. This can be done in one of two ways: ALTER SESSION SET plsql_debug=TRUE; CREATE OR REPLACE ... /* create the library units - debug information will be generated / / recompile specific library unit with debug option */ alter [PROCEDURE | FUNCTION | PACKAGE BODY] compile debug;

Topics

#DBMS_TRACE#TRACE_ENABLED_EXCEPTIONS#PL/SQL tracing#DEBUG compilation

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice