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 AnswersA: 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.
C) is correct too: the signature of process_emp is changed and process_emp is re-compiled successfully, a new timestamp would be recorded in XXX_dependencies, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
Every the moment inside a although we decide on blogs that we study. Listed beneath are the latest sites that we decide on.
We came across a cool site that you may appreciate. Take a appear when you want.
check below, are some absolutely unrelated internet sites to ours, on the other hand, they’re most trustworthy sources that we use
please check out the sites we follow, like this one, as it represents our picks through the web
please stop by the internet sites we adhere to, like this a single, because it represents our picks from the web
usually posts some extremely exciting stuff like this. If youre new to this site
below youll find the link to some web sites that we consider you should visit
Here is a good Weblog You may Find Exciting that we Encourage You
here are some links to sites that we link to since we assume they’re really worth visiting
we came across a cool website that you just could delight in. Take a search if you want
always a significant fan of linking to bloggers that I like but dont get a lot of link enjoy from
check beneath, are some entirely unrelated websites to ours, having said that, they’re most trustworthy sources that we use
we like to honor lots of other world wide web sites around the net, even if they arent linked to us, by linking to them. Below are some webpages worth checking out
12/7/2016 Appreciate the site– extremely easy to navigate and much to explore!
http://www.jbh.org.il/content/5747/