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

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.)

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.)

A.
MY_PROC2 is not recompiled.

B.
MY_PROC1 is recompiled but remains unchanged.

C.
MY_PROC2 is recompiled but remains unchanged.

D.
MY_PROC1 is recompiled without the debugging code.



Leave a Reply 10

Your email address will not be published. Required fields are marked *


samkelo siyabonga ngubo

samkelo siyabonga ngubo

C,D

Ashish

Ashish

Should be A and D.
Refer Fine grained invalidation in oracle docs. According to which the procedure gets invalidated only when the referenced package’s particular(referenced) item changes.

Uladzimir

Uladzimir

you are wrong, read documetation carefully

Nishdha

Nishdha

A and D are correct answers