Complex Question 3

[hanyfreedom]

Procedure PROCESS_EMP references the table EMP.
Procedure UPDATE_EMP updates rows if table EMP through
procedure PROCESS_EMP.
There is a remote procedure QUERY_EMP that queries the EMP table
through the local procedure PROCESS_EMP.
The dependency mode is set to TIMESTAMP in this session.

Which two statements are true? (Choose two)

A. If the signature of procedure PROCESS_EMP is modified and successfully
recompiles, the EMP table is invalidated.
B. If internal logic of procedure PROCESS_EMP is modified and successfully
recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for
the first time.
C. If the signature of procedure PROCESS_EMP is modified and successfully
recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for
the first time.
D. If internal logic of procedure PROCESS_EMP is modified and successfully
recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the
first time.
E. If internal logic of procedure PROCESS_EMP is modified and successfully
recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the
second time.

[ABUSANAD]

السلام عليكم و رحمة الله -تعالى- و بركاته,
الاخ العزيز هاني الاجابة الصحيحة هي 'D' & 'B'.

الشرح:-

B- If internal logic of procedure PROCESS_EMP is modified and successfully recompiled, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.

هنا اجراء UPDATE_EMP يعتمد على اجراء PROCESS_EMP ونط الاعتماد هو "TIMESTAMP".فعندما يكون تغيير ناجح في اجراء PROCESS_EMP فان اجراء UPDATE_EMP يكون معطل ويحتاج الى ان يركب بنجاح من جديد عندما يستدعى من اول مرة.

D- If internal logic of procedure PROCESS_EMP is modified and successfully recompiled, QUERY_EMP gets invalidated and will recompile when invoked for the second time.

هنا اجراء QUERY_EMP يعتمد على اجراء PROCESS_EMP و لكن من بعد اي ليس في نفس SCHEMA ونمط الاعتماد هو "TIMESTAMP".فعندما يكون تغيير ناجح في اجراء PROCESS_EMP فان اجراء QUERY_EMP يكون معطل و يحتاج ان يركب بنجاح من جديد عندما يستدعى من المرة الثانية.

تحياتي...