Concept drill
locking
GATE CSE & IT · Transactions · 2004-2019
3
PYQs
100%
keyed
0
elite explanations
3
years appeared
Study anchor
Korth — Database System Concepts
Relational model, SQL, normalization, transactions
Practice action
Start latest PYQPYQs in this concept
All concepts →2019 PYQ
Consider the following two statements about database transaction schedules: I. Strict two-phase locking protocol generates conflict serializable schedules that are also recoverable...
mediumanswer keybasic explanation
2007 PYQ
Consider the following two transactions: T 1 and T 2 . T 1 : read (A); T 2 : read (B); read (B); read (A); if A = 0 then B ← B + 1; if B ≠ 0 then A ← A - 1; write (B); write (A); W...
mediumanswer key
2004 PYQ
Which level of locking provides the highest degree of concurrency in a relational database?
easyanswer keybasic explanation