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?
A.
It allows tracing of exceptions raised by all subprograms executed in the session.
B.
It allows tracing of user-defined exceptions raised by all subprograms executed in the session.
C.
It allows tracing of system-defined exceptions raised by all subprograms executed in the
session.
D.
It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and
executed in the session.
Tracing Exceptions
Two levels of exception tracing are available:
Level 1: Trace all exceptions. This corresponds to TRACE_ALL_EXCEPTIONS.
Level 2: Trace exceptions raised in enabled program units only. This corresponds to TRACE_ENABLED_EXCEPTIONS.
https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_trace.htm
D