Oracle
1Z0-144 · Question #12
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…
The correct answer is D. Procedure A is invalidated and recompiles when invoked the next time. See the full explanation below for the reasoning.
Question
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?
Options
- AProcedure A is invalidated and recompiled immediately.
- BThere is no effect on procedure A and it runs successfully.
- CProcedure B is invalidated and recompiled again when invoked.
- DProcedure A is invalidated and recompiles when invoked the next time.
How the community answered
(28 responses)- A11% (3)
- B4% (1)
- C4% (1)
- D82% (23)
Community Discussion
No community discussion yet for this question.