You execute the following command in the user session: SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command?

The correct answer is B. It enables all PL/SQL blocks that are compiled subsequently in the session for tracing. PLSQL_DEBUG specifies whether or not PL/SQL library units will be compiled for debugging. PL/SQL library units will be compiled for debugging PL/SQL library units will be compiled for normal execution When PLSQL_DEBUG is set to true, PL/SQL library units are always compiled…

Debugging and Profiling PL/SQL Code

Question

You execute the following command in the user session:

SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command?

Options

AAll PL/SQL blocks that are executed subsequently in the session are traced.
BIt enables all PL/SQL blocks that are compiled subsequently in the session for tracing.
COnly anonymous PL/SQL blocks that are executed subsequently in the session are traced.
DIt enables only named PL/SQL blocks that are executed subsequently in the session for tracing.

How the community answered

(32 responses)

A
6% (2)
B
78% (25)
C
13% (4)
D
3% (1)

Explanation

PLSQL_DEBUG specifies whether or not PL/SQL library units will be compiled for debugging. PL/SQL library units will be compiled for debugging PL/SQL library units will be compiled for normal execution When PLSQL_DEBUG is set to true, PL/SQL library units are always compiled INTERPRETED in order to be debuggable. When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. The value of this parameter is stored persistently with each library unit.

Topics

#PLSQL_DEBUG#debug compilation#session parameter#ALTER SESSION

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice