Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Explain concurrency control?
Concurrency control
Oracles multiversion concurrency control varies from the concurrency mechanism used by some other data base vendors. Read only queries are given a read -consistent snapshot which is view if the data base as it existed at the particular point in time, having all update that we were committed by that point in time and not containing any updates that were not committed at any point in time therefore read clock are not used in read only queries don't interfere with other data base activity in term of locking.
Managed stand by data base
To make sure high availability oracle provide a managed stand by data base future A stand by data base is a copy of the regular data base i.e. in solved on the separate system. If a catastrophic failure occur on the primary system, the stand by system is activate and take over there by minimizing effect on failure on a availability. Oracle keeps the stand by data base up to date by constantly applying archived redo logs that are shipped from the primary data base the back up data base can be brought online in readonly mode and used for reporting and decision support queries
What is the use of Union and intersection operation? Union: The result of this operation contains all tuples that are either in r1 or in r2 or in both r1 and r2.Duplicate tuple
Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b
Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t
WOUND-WAIT
Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t
i am not clear with the climetic condition of the north indian plain. can u plz explain it for me
Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of
Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager
what is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?what is indexin
The issues relating to the Design of the Physical Database Files Physical File is a file as stored on the disk. The major issues relating to physical files are: • Cons
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd