Which of the following is NOT a variant of time stamp-based method of…
2021
Which of the following is NOT a variant of time stamp-based method of concurrency control in database management system?
- A.
Total time stamp ordering
- B.
Partial time stamp ordering
- C.
Multi version time stamp ordering
- D.
Multilevel time stamp ordering
Attempted by 108 students.
Show answer & explanation
Correct answer: D
Time stamp-based concurrency control methods include Total Time Stamp Ordering and Multi-Version Time Stamp Ordering. These protocols use timestamps to manage transaction ordering. Multilevel Time Stamp Ordering is not a standard or recognized variant of timestamp-based concurrency control methods in database management systems.
The commonly recognized timestamp-based concurrency control variants in DBMS are mainly:
Basic/Total Timestamp Ordering
Partial Timestamp Ordering
Multiversion Timestamp Ordering (MVTO)
Apart from these, some books may discuss modified or strict versions such as:
Strict Timestamp Ordering
Thomas Write Rule (optimization over timestamp ordering)
But “Multilevel Timestamp Ordering” is not considered a standard timestamp-based concurrency control method in DBMS.