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 Dynamic Two-Phase Locking
Here a transaction locks a data item instantly earlier than any operation is applied on the data item. After finishing all the operations on all the data items, it releases all the locks. An instance of dynamic 2PL is as following
X(X)
Read (X)
X=X+M
Write (X)
X (Y)
Read (Y)
Y=Y+N
Write Y
Unlock (Y)
Unlock (X)
What do you understand by ACID? - ACID (Atomicity Consistency Isolation Durability) is a quality sought after in a reliable database. Here's the relevance of each quality:
Which is another name for weak entity? Child is another name of weak entity.
Three way to handle missing field val
What is the difference between serial and sequential files? How searching is applied on both? Ans: A serial file is one where the records have been stored in the order where
Determine the method of Choosing Algorithms In general, most of operations are easy and have a satisfactory algorithm since description of what is to be done also shows how i
Which method of access uses key transformation? A Hash method of access uses key transformation.
#question benefits and limitations of data models..
Q. Why would you choose a database system instead of simply storing data in operating system file? Define at a base concept in details. Sol. Advantages of Database over Fil
List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view
Differentiate between horizontal & mixed horizontal fragmentation?
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