Question 11225 – Algorithms
May 13, 2024Question 9286 – Database-Management-System
May 13, 2024Database-Management-System
| Question 154 |
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
I. 2-phase locking II. TIme-stamp ordering
| I only | |
| II only | |
| Both I and II | |
| Neither I nor II |
Question 154 Explanation:
― Two-phase locking protocol (2PLP) ensures the conflict serializable schedule but it may not free from deadlock.
― Timestamp ordering protocol ensures conflict serializability and free from deadlock.
― Timestamp ordering protocol ensures conflict serializability and free from deadlock.
Correct Answer: B
Question 154 Explanation:
― Two-phase locking protocol (2PLP) ensures the conflict serializable schedule but it may not free from deadlock.
― Timestamp ordering protocol ensures conflict serializability and free from deadlock.
― Timestamp ordering protocol ensures conflict serializability and free from deadlock.
Subscribe
Login
0 Comments