Lock-Based Protocols MCQ

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

• Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
  ক

  Record controller

  খ

  Exclusive lock

  গ

  Authorization rule

  ঘ

  Two phase lock
• The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
  ক

  Table-level

  খ

  Page-level

  গ

  Row-level

  ঘ

  Field-level
• All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.
  ক

  Scheduler

  খ

  DBMS

  গ

  Lock manager

  ঘ

  Locking agent
• Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other
  ক

  Concurrency

  খ

  Deadlock

  গ

  Backup

  ঘ

  Recovery
• If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.
  ক

  Explicit lock in exclusive mode

  খ

  Implicit lock in shared mode

  গ

  Explicit lock in shared mode

  ঘ

  Implicit lock in exclusive mode
• Which of the following is the block that is not permitted to be written back to the disk?
  ক

  Dead code

  খ

  Read only

  গ

  Pinned

  ঘ

  Zapped
• Which of the following protocols ensures conflict serializability and safety from deadlocks?
  ক

  Two-phase locking protocol

  খ

  Time-stamp ordering protocol

  গ

  Graph based protocol

  ঘ

  None of the mentioned
• Which of the following are introduced to reduce the overheads caused by the log-based recovery?
  ক

  Checkpoints

  খ

  Indices

  গ

  Deadlocks

  ঘ

  Locks
• A lock that allows concurrent transactions to access different rows of the same table is known as a
  ক

  Database-level lock

  খ

  Table-level lock

  গ

  Page-level lock

  ঘ

  Row-level lock
• In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?
  ক

  Triggers

  খ

  Pointers

  গ

  Locks

  ঘ

  Cursors