Consider the following statements:
Statement I: Conservative 2PL is a deadlock-free protocol.
Statement II: Thomas's write rule enforces conflict serializability.
Statement III: The timestamp ordering protocol ensures serializability based on the order of transaction timestamps.
Which of the following is correct?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. Statements I and III true, Statement II false
Explanation
Conservative 2PL locks everything in advance, so no deadlock. Thomas's write rule ignores obsolete writes and allows view-serializable but not conflict-serializable schedules. TO orders by timestamp.More Database Management Systems questions
- Consider the following statements: Statement I: Composite attributes cannot be divided into smaller subparts. Statement II: A complex attri…
- Size and complexity are a part of
- Which of the following is an indirect measure of product?
- Which metrics are derived by normalizing quality and/or productivity measures by considering the size of the software that has been produce…
- A company has a choice of two languages L1 and L2 to develop a software for their client. Number of LOC required to develop an application…
- A software project was estimated at 864 Function Points. A six-person team will be assigned to the project consisting of one requirement ga…