Question 4889 – UGC NET CS 2018-DEC Paper-2
November 5, 2023Software-Engineering
November 5, 2023Question 17080 – NTA UGC NET JUNE-2023 Paper-2
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:
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.
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
Subscribe
Login
0 Comments