DBMS · Question 30 · Hard
Under the wound-wait deadlock-prevention scheme, an older transaction Ti requests a lock held by a younger transaction Tj. What happens?
- Ti waits until Tj releases the lock
- Tj is aborted (wounded) and later restarted, and Ti gets the lock
- Ti is aborted and restarted with the same timestamp
- Both transactions are aborted
Answer and explanation
Answer: B. Tj is aborted (wounded) and later restarted, and Ti gets the lock
Explanation: In wound-wait, an older transaction never waits for a younger one: it wounds (aborts) the younger holder. A younger requester waits for an older holder. Letting the older one wait is the wait-die rule.
Previous: Consider the schedule S: w1(X), r2(X), w2(Y), c2, c1, where ri, wi and ci are…
Practise dbms
Try a fresh set of dbms questions with an explanation after every answer, free and without signing up: DBMS practice. Or sit a full placement mock test.
More dbms questions
- Relation R(A, B, C, D) has the functional dependencies A → B, B → C and C → A…
- Relation R(A, B, C, D, E) has exactly two candidate keys, A and B. How many…
- Consider the schedule S: w1(X), r2(X), w2(Y), c2, c1, where ri, wi and ci are…
More technical & programming practice
SQL · Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming
LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge