Snapshot Isolation MCQ

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

• An application developer can guard against certain snapshot anomalies by appending a ______ clause to the SQL select query.
  ক

  For update

  খ

  For read

  গ

  For write

  ঘ

  None of the mentioned
• Each of a pair of transactions has read data that is written by the other, but there is no data written by both transactions, is referred to as
  ক

  Read skew

  খ

  Update skew

  গ

  Write lock

  ঘ

  None of the mentioned
• When a transaction Ti attempts to update a data item, it requests a _________ on that data item.
  ক

  Read lock

  খ

  Update lock

  গ

  Write lock

  ঘ

  Chain lock
• Under first updater wins the system uses a __________ mechanism that applies only to updates.
  ক

  Close

  খ

  Read

  গ

  Locking

  ঘ

  Beat
• Lost update problem is
  ক

  Second update overwrites the first

  খ

  First update overwrites the second

  গ

  The updates are lost due to conflicting problem

  ঘ

  None of the mentioned
• Snapshot isolation is used to give
  ক

  Transaction a snapshot of the database

  খ

  Database a snapshot of the transaction

  গ

  Database a snapshot of committed values in the transaction

  ঘ

  Transaction a snapshot of the database and Database a snapshot of committed values in the transaction
• Snapshot isolation is a particular type of ______________ scheme.
  ক

  Concurrency-control

  খ

  Concurrency-allowance

  গ

  Redirection

  ঘ

  Repetition-allowance