Which statement correctly describes what happens when procedure A is invoked at 1 PM?

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?

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.



Leave a Reply 5

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


Ritam

Ritam

A stored procedure becomes invalid typically when a referenced object is altered or becomes invalid.

krmaca

krmaca

why not A?