Normalization
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 329
|
Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock :
I. 2-phase locking
II. Time phase ordering
|
Both I & II
|
|
|
II only
|
|
|
I only
|
|
|
Neither I nor II
|
Question 329 Explanation:
2-phase locking : 2-phase locking ensures conflict serializability and does not ensure freedom from deadlock.
Time phase ordering: It ensures both conflict serializability and freedom from deadlock.
Time phase ordering: It ensures both conflict serializability and freedom from deadlock.
Correct Answer: B
Question 329 Explanation:
2-phase locking : 2-phase locking ensures conflict serializability and does not ensure freedom from deadlock.
Time phase ordering: It ensures both conflict serializability and freedom from deadlock.
Time phase ordering: It ensures both conflict serializability and freedom from deadlock.