Validation Based Protocols MCQ

Test your knowledge with important Validation Based Protocols MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Validation Based Protocols MCQs at Bissoy

• State true or false: We determine the serializability order of validation protocol by the validation ordering technique
  ক

  True

  খ

  False
• State true or false: Locking and timestamp ordering force a wait or rollback whenever a conflict is detected.
  ক

  True

  খ

  False
• Which of the following timestamps is used to record the time when a database has completed its write operation?
  ক

  Start(i)

  খ

  Validation(i)

  গ

  Finish(i)

  ঘ

  Write(i)
• Which of the following timestamps is used to record the time when a transaction has finished its read phase?
  ক

  Start(i)

  খ

  Validation(i)

  গ

  Finish(i)

  ঘ

  Write(i)
• Which of the following timestamp is used to record the time at which the transaction started execution?
  ক

  Start(i)

  খ

  Validation(i)

  গ

  Finish(i)

  ঘ

  Write(i)
• Read only operations omit the _______ phase
  ক

  Read phase

  খ

  Validation phase

  গ

  Write phase

  ঘ

  None of the mentioned
• During the _________ phase the validation test is applied to the transaction
  ক

  Read phase

  খ

  Validation phase

  গ

  Write phase

  ঘ

  None of the mentioned
• During __________ phase, the system reads data and stores them in variables local to the transaction.
  ক

  Read phase

  খ

  Validation phase

  গ

  Write phase

  ঘ

  None of the mentioned
• The _________ requires each transaction executes in two or three different phases in its lifetime
  ক

  Validation protocol

  খ

  Timestamp protocol

  গ

  Deadlock protocol

  ঘ

  View protocol