Recent questions tagged databases

0 votes
0 answers
157
Show that the two phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.
1 votes
2 answers
158
A database relation has10 attributes {A,BCD,E,F,J} “CDEF” is known to be a candidate key of relation . There may be other candidate keys, which are unknown. What is t...
1 votes
1 answer
159
In multiple Granularity locking protocol at a particular node transaction T1 is holding SIX LOCK. When transaction T2 is also requesting a lock, at that node which other ...