Home »
MCQs »
DBMS MCQs
DBMS Timestamp Ordering Protocol MCQs
DBMS Timestamp Ordering Protocol MCQs: This section contains multiple-choice questions and answers on Timestamp Ordering Protocol in DBMS.
Submitted by Anushree Goswami, on April 20, 2022
1. Transactions are ordered by their ___ using the Timestamp Ordering Protocol.
- Time
- Stamps
- Timestamps
- None
Answer: C) Timestamps
Explanation:
Transactions are ordered by their Timestamps using the Timestamp Ordering Protocol.
Discuss this Question
2. It is the ___ order of the transaction creation that determines the order of transactions.
- Ascending
- Descending
- Both A and B
- None of the above
Answer: A) Ascending
Explanation:
It is the ascending order of the transaction creation that determines the order of transactions.
Discuss this Question
3. Which of the following statements is TRUE?
- Older transactions have a lower priority, so they execute first.
- Older transactions have a higher priority, so they execute last.
- Older transactions have a higher priority, so they execute first.
- Older transactions have a lower priority.
Answer: C) Older transactions have a higher priority, so they execute first.
Explanation:
Older transactions have a higher priority, so they execute first.
Discuss this Question
4. Using ___ this protocol determines the timestamp of the transaction.
- System time
- Logical Counter
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Using the system time or logical counter, this protocol determines the timestamp of the transaction.
Discuss this Question
5. During ___, the lock-based protocol controls the order in which conflicting pairs of transactions are handled.
- Begin
- End
- Execution
- None
Answer: C) Execution
Explanation:
During execution, the lock-based protocol controls the order in which conflicting pairs of transactions are handled.
Discuss this Question
6. When a transaction is ___, timestamp-based protocols begin to work.
- Created
- Aborted
- Committed
- Rollbacked
Answer: A) Created
Explanation:
When a transaction is created, timestamp-based protocols begin to work.
Discuss this Question
7. The timestamp ordering protocol also keeps track of the last ___ operation performed on the data.
- Read
- Write
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The timestamp ordering protocol also keeps track of the last 'read' and 'write' operation performed on the data.
Discuss this Question
8. ___ is guaranteed by the TO protocol.
- Realization
- Serialization
- Dilation
- None
Answer: B) Serialization
Explanation:
Serialization is guaranteed by the TO protocol.
Discuss this Question
9. No transaction ever waits due to the TS protocol, which ensures there is no ___.
- Deadlock
- Lock
- Deadstate
- Deadset
Answer: A) Deadlock
Explanation:
No transaction ever waits due to the TS protocol, which ensures there is no deadlock.
Discuss this Question
10. TO protocol may not allow the schedule to be ___.
- Recovered
- Cascade-free
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
TO protocol may not allow the schedule to be recovered or cascade-free.
Discuss this Question