Timestamp based Protocols MCQ

Test your knowledge with important Timestamp based Protocols MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Timestamp based Protocols MCQs on Bissoy. Bissoy App

• In timestamp ordering protocol, suppose that the transaction Ti issues write(Q) and TS(Ti)<W-timestamp(Q), then
  ক

  Read operation is executed

  খ

  Read operation is rejected

  গ

  Write operation is executed

  ঘ

  Write operation is rejected
• In timestamp ordering protocol, suppose that the transaction Ti issues read(Q) and TS(Ti)<W-timestamp(Q), then
  ক

  Read operation is executed

  খ

  Read operation is rejected

  গ

  Write operation is executed

  ঘ

  Write operation is rejected
• Which of the following timestamp based protocols generates serializable schedules?
  ক

  Thomas write rule

  খ

  Timestamp ordering protocol

  গ

  Validation protocol

  ঘ

  None of the mentioned
• State true or false: The Thomas write rule has a greater potential concurrency than the timestamp ordering protocol
  ক

  True

  খ

  False
• The default timestamp ordering protocol generates schedules that are
  ক

  Recoverable

  খ

  Non-recoverable

  গ

  Starving

  ঘ

  None of the mentioned
• A ________ ensures that any conflicting read and write operations are executed in timestamp order
  ক

  Organizational protocol

  খ

  Timestamp ordering protocol

  গ

  Timestamp execution protocol

  ঘ

  802-11 protocol
• R-timestamp(Q) denotes?
  ক

  The largest timestamp of any transaction that can execute write(Q) successfully

  খ

  The largest timestamp of any transaction that can execute read(Q) successfully

  গ

  The smallest timestamp of any transaction that can execute write(Q) successfully

  ঘ

  The smallest timestamp of any transaction that can execute read(Q) successfully
• W-timestamp(Q) denotes?
  ক

  The largest timestamp of any transaction that can execute write(Q) successfully

  খ

  The largest timestamp of any transaction that can execute read(Q) successfully

  গ

  The smallest timestamp of any transaction that can execute write(Q) successfully

  ঘ

  The smallest timestamp of any transaction that can execute read(Q) successfully
• A logical counter is _________ after a new timestamp has been assigned
  ক

  Incremented

  খ

  Decremented

  গ

  Doubled

  ঘ

  Remains the same
• Which of the following cannot be used to implement a timestamp
  ক

  System clock

  খ

  Logical counter

  গ

  External time counter

  ঘ

  None of the mentioned