Oracle
1Z0-147 · Question #13
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…
See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.