QUESTION 84Procedure 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)BE
(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.