1 رد (ردود) على هذا الموضوع

[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 يكون معطل و يحتاج ان يركب بنجاح من جديد عندما يستدعى من المرة الثانية.

تحياتي...