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.

  1. Time
  2. Stamps
  3. Timestamps
  4. 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.

  1. Ascending
  2. Descending
  3. Both A and B
  4. 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?

  1. Older transactions have a lower priority, so they execute first.
  2. Older transactions have a higher priority, so they execute last.
  3. Older transactions have a higher priority, so they execute first.
  4. 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.

  1. System time
  2. Logical Counter
  3. Both A and B
  4. 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.

  1. Begin
  2. End
  3. Execution
  4. 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.

  1. Created
  2. Aborted
  3. Committed
  4. 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.

  1. Read
  2. Write
  3. Both A and B
  4. 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.

  1. Realization
  2. Serialization
  3. Dilation
  4. 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 ___.

  1. Deadlock
  2. Lock
  3. Deadstate
  4. 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 ___.

  1. Recovered
  2. Cascade-free
  3. Both A and B
  4. 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





👇 More MCQs (Category-Wise) 👇

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Commerce MCQs

Graphic Design Softwares MCQs

General Knowledge (GK) MCQs

Class-wise MCQs

Others

Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.