Home »
MCQs »
DBMS MCQs
DBMS Thomas Write Rule MCQs
DBMS Thomas Write Rule MCQs: This section contains multiple-choice questions and answers on Thomas Write Rule in DBMS.
Submitted by Anushree Goswami, on April 21, 2022
1. ___ order is guaranteed by the Thomas Write Rule.
- Reliability
- Serializability
- Indemnity
- Periodic
Answer: B) Serializability
Explanation:
Serializability order is guaranteed by the Thomas Write Rule.
Discuss this Question
2. ___ algorithm is improved by the Thomas Write Rule.
- Concurrency
- Lock-based
- Timestamp Ordering
- Validation based
Answer: C) Timestamp Ordering
Explanation:
Timestamp ordering algorithm improved by Thomas Write Rule.
Discuss this Question
3. If TS(T) = R_TS(X), operation X is ___ and transaction T is ___.
- Rejected, Aborted
- Aborted, Rejected
- Rejected
- Aborted
Answer: A) Rejected, Aborted
Explanation:
If TS(T) = R_TS(X), operation X is rejected and transaction T is aborted.
Discuss this Question
4. The W_TS(X) operation of the transaction will not be executed if TS(T) _? W_TS(X).
- <
- =
- >
- =>
Answer: A) <
Explanation:
The W_TS(X) operation of the transaction will not be executed if TS(T) < W_TS(X).
Discuss this Question
5. In the absence of conditions 1 or 2, the ____ operation can be executed by transaction Ti, and W_TS(X) pointing to TS(T).
- READ
- WRITE
- EXECUTE
- UPDATE
Answer: B) WRITE
Explanation:
In the absence of conditions 1 or 2, the WRITE operation can be executed by transaction Ti, and W_TS(X) pointing to TS(T).
Discuss this Question
6. Using the Thomas write rule, some ___ schedules can be permitted without conflicting with ___.
- Serial
- Non-serial
- Serializable
- Non-serializable
Answer: C) Serializable
Explanation:
Using the Thomas write rule, some serializable schedules can be permitted without conflicting with serializable.
Discuss this Question
7. A rule written by Thomas ensures that T2's ____ cannot be seen by any transaction in which T2 has committed (W(A)).
- Read
- Write
- Commit
- Rollback
Answer: B) Write
Explanation:
A rule written by Thomas ensures that T2's write cannot be seen by any transaction in which T2 has committed (W(A)).
Discuss this Question
8. The ___ schedule can be generated by deleting the write operation in T2, which has a W(A) Commit.
- Conflict Serial
- Conflict Non-serial
- Non-conflict Serializable
- Conflict Serializable
Answer: D) Conflict Serializable
Explanation:
The conflict serializable schedule can be generated by deleting the write operation in T2, which has a W(A) Commit.
Discuss this Question