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.
Subscribe
Login
0 Comments