Q11hard
In the context of database locking, what is the difference between Deadlock and Starvation?
Back to Database Management Systems
15 Questions Total
Concurrency Control MCQs
Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.
Zero-leak answer engine • Rate-limited explanations
Practice in Timed ModeQ12hard
User A and User B are both trying to buy the last ticket for a concert. 1. User A reads the ticket count (Count = 1). 2. User B reads the ticket count (Count = 1). 3. User A decrements the count and writes (Count = 0). 4. User B decrements the count and writes (Count = 0). Both users receive a "Success" message, but only one physical ticket exists. Which concurrency problem occurred?
Q13medium
Analyze the following SQL execution sequence between two sessions. What will Transaction 1 see at Time T3?
Q14medium
The Thomas Write Rule is an optimization of the Basic Timestamp Ordering protocol. What does it do when a transaction Ti tries to write to a data item that already has a Write-Timestamp newer than Ti's own timestamp?
Q15easy
A schedule is considered Conflict Serializable if: