Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024HCU PHD CS MAY 2016
|
Question 2
|
Which of the following protocols has all of the properties:
(i) imposing restrictions on the order of items being accessed
(ii) ensuring serializability without the requirement of two phase locking, and
(iii) additionally ensuring deadlock freedom.
|
Three phase locking
|
|
|
Timestamp ordering
|
|
|
Graph based locking
|
|
|
Strict two phase locking
|
Question 2 Explanation:
Graph based protocol ensures serializability and deadlock freedom and has restrictions on items being accessed,because before acquiring access to elements we have to acquire lock on parents.
Correct Answer: C
Question 2 Explanation:
Graph based protocol ensures serializability and deadlock freedom and has restrictions on items being accessed,because before acquiring access to elements we have to acquire lock on parents.