...
GATE 2004
October 16, 2023
UGC NET CS 2015 June Paper-3
October 16, 2023
GATE 2004
October 16, 2023
UGC NET CS 2015 June Paper-3
October 16, 2023

NTA-UGC-NET 2021 Dec & 2022 June Paper-2

Question 7
Consider the following statements:
Statement I: Conservative 2 PL is a deadlock-free protocol.
Statement II: Thomas’s write rule enforces conflict serializability.
Statement III: Timestamp ordering protocol ensures serializability based on the order of transaction timestamps.
Which of the following is correct?
A
Statement I, Statement II true and Statement III false
B
Statement I, Statement III true and Statement II false
C
Statement I, Statement II false and Statement III true
D
Statement I, Statement II and Statement III true
Question 7 Explanation: 
TRUE: Statement I: Conservative 2 PL is a deadlock-free protocol.
TRUE: Statement II: Thomas’s write rule enforces conflict serializability.
TRUE: Statement III: Timestamp ordering protocol ensures serializability based on the order of transaction timestamps.
Correct Answer: D
Question 7 Explanation: 
TRUE: Statement I: Conservative 2 PL is a deadlock-free protocol.
TRUE: Statement II: Thomas’s write rule enforces conflict serializability.
TRUE: Statement III: Timestamp ordering protocol ensures serializability based on the order of transaction timestamps.
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!