Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 692
|
In concurrency control a situation where ‘ A transaction may be waiting for an x-lock on an item, while a sequence of other transactions request and are granted on s-lock on the same item’. May lead to:
|
Deadlock
|
|
|
Starvation
|
|
|
Conflict
|
|
|
Lock failure
|
Question 692 Explanation:
In concurrency control a situation where ‘ A transaction may be waiting for an x-lock on an item, while a sequence of other transactions request and are granted on s-lock on the same item’ may lead to starvation.
Reasons of Starvation:
1. If waiting scheme for locked items is unfair. ( priority queue )
2. Victim selection. ( same transaction is selected as a victim repeatedly )
3. Resource leak.
(Via denial-of-service attack)
Reasons of Starvation:
1. If waiting scheme for locked items is unfair. ( priority queue )
2. Victim selection. ( same transaction is selected as a victim repeatedly )
3. Resource leak.
(Via denial-of-service attack)
Correct Answer: B
Question 692 Explanation:
In concurrency control a situation where ‘ A transaction may be waiting for an x-lock on an item, while a sequence of other transactions request and are granted on s-lock on the same item’ may lead to starvation.
Reasons of Starvation:
1. If waiting scheme for locked items is unfair. ( priority queue )
2. Victim selection. ( same transaction is selected as a victim repeatedly )
3. Resource leak.
(Via denial-of-service attack)
Reasons of Starvation:
1. If waiting scheme for locked items is unfair. ( priority queue )
2. Victim selection. ( same transaction is selected as a victim repeatedly )
3. Resource leak.
(Via denial-of-service attack)