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.
Explanation:
B: The UPDATE_EMP references the local Procedure PROCESS_EMP. Local Dependent
objects are immediately set to invalid whenever the referenced object is changed. The Oracle
server will recompile the dependent object upon execution.
E: Since QUERY_EMP is a remote procedure, this procedure will be set to invalid the first time
that it executes and it will recompile the second time that it is invoked
Incorrect Answers:
A: We are using Timestamp checking not signature checking. The EMP Table is the referenced
object. If the definition of a referenced object is changed or modified, its dependent objects
become invalid. Modifying any of the dependent procedures (Emp Table in this case) will not
invalidate the referenced object regardless of the mode to check dependencies.
C: In this scenario we are using TimeStamp method not the Signature method.
D: Since QUERY_EMP is a remote procedure, this procedure will be set to invalid the first time
that it executes and it will recompile the second time that it is invoked.