Consider the following scenario:
Local procedure a calls remote procedure B
Procedure A was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.
The dependency mode is set to timestamp.
Which statement correctly describes what happens when procedure A is invoked at 1 PM?
A. Procedure A is invalidated and recompiled immediately.
B. There is no effect on procedure A and it runs successfully.
C. Procedure B is invalidated and recompiled again when invoked.
D. Procedure A is invalidated and recompiles when invoked the next time.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
I think correct answer is D.
https://docs.oracle.com/database/121/ADFNS/adfns_dependencies.htm#ADFNS99978
“In time-stamp dependency mode, when a local stored procedure calls a remote procedure, Oracle Database compares the time stamp that the local procedure has for the remote procedure to the current time stamp of the remote procedure. If the two time stamps match, both the local and remote procedures run. Neither is recompiled.
If the two time stamps do not match, the local procedure is invalidated and an error is returned to the calling environment. All other local procedures that depend on the remote procedure with the new time stamp are also invalidated.”
https://asktom.oracle.com/pls/asktom/asktom.search?tag=compile-procedure-automatically-how-to-avoid-cascading-invalidations
“If procedure A calls procedure B and B is “changed”, then A is directly affected and must be recompiled. There is no “auto recompile A when B changes” option — although A will recompile itself automatically the next time it is run.”