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.
D
A stored procedure becomes invalid typically when a referenced object is altered or becomes invalid.
D
why not A?
??