View the Exhibit and examine the code and its outcome on execution: What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

The correct answer is C. MY_PROC2 is recompiled but remains unchanged. D. MY_PROC1 is recompiled without the debugging code. Changing the value of one of the constants forces all the dependent units of the package to recompile with the new value. For example, changing the value of debug to FALSE would cause my_proc1 to be recompiled without the debugging code. my_proc2 would also be recompiled, but…

Configuring JDBC Data Sources

Question

View the Exhibit and examine the code and its outcome on execution:

What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

Exhibit

Options

AMY_PROC2 is not recompiled.
BMY_PROC1 is recompiled but remains unchanged.
CMY_PROC2 is recompiled but remains unchanged.
DMY_PROC1 is recompiled without the debugging code.

How the community answered

(21 responses)

A
10% (2)
B
14% (3)
C
76% (16)

Explanation

Changing the value of one of the constants forces all the dependent units of the package to recompile with the new value. For example, changing the value of debug to FALSE would cause my_proc1 to be recompiled without the debugging code. my_proc2 would also be recompiled, but my_proc2 would be unchanged because the value of trace did not change.

Topics

#conditional compilation#debug flag#procedure recompilation#PL/SQL

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice