GATE 2004
October 16, 2023UGC NET CS 2015 June Paper-3
October 16, 2023NTA-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?
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?
| Statement I, Statement II true and Statement III false | |
| Statement I, Statement III true and Statement II false | |
| Statement I, Statement II false and Statement III true | |
| 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.
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.
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.
Subscribe
Login
0 Comments