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.