Oracle
1Z0-147 · Question #13
1Z0-147 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Question
Procedure PROCESS_EMP references the table EMP. Procedure UPDATE_EMP updates rows in 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.)
Options
- AIf the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is invalidated.
- BIf internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
- CIf the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
- DIf internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the first time.
- EIf internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.