NTA UGC NET JUNE-2023 Paper-2
|
Question 5
|
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
Statement I: Two phase locking
Statement II: Timestamp ordering
In the light of the above statements, choose the most appropriate answer from the options given below:
Statement I: Two phase locking
Statement II: Timestamp ordering
In the light of the above statements, choose the most appropriate answer from the options given below:
|
Both statement I and statement II are correct
|
|
|
Both statement I and statement II are incorrect
|
|
|
Statement I is correct but Statement Ii is incorrect
|
|
|
Statement I is incorrect but Statement Ii is correct
|
Question 5 Explanation:
The correct answer is “Statement I is incorrect, but Statement II is correct.”
Two-phase locking (Statement I) ensures conflict serializability but does not guarantee freedom from deadlock.
Timestamp ordering (Statement II) is a protocol that ensures both conflict serializability and freedom from deadlock.
Correct Answer: D
Question 5 Explanation:
The correct answer is “Statement I is incorrect, but Statement II is correct.”
Two-phase locking (Statement I) ensures conflict serializability but does not guarantee freedom from deadlock.
Timestamp ordering (Statement II) is a protocol that ensures both conflict serializability and freedom from deadlock.