As an Amazon Associate I earn from qualifying purchases.

Lock Based Protocols MCQs Quiz Online PDF Download eBook

Solve Lock Based Protocols Multiple Choice Questions (MCQ), lock based protocols quiz answers PDF data science practice test for online courses. Learn concurrency control Multiple Choice Questions and Answers (MCQs), "Lock Based Protocols Quiz" questions and answers for top online computer science programs. Learn multiple granularity locking, concurrency in index structures, deadlock handling, lock based protocols test prep for master's degree in computer science.

"A two-phase locking protocol variant that requires that all locks be held until the transaction commit is called" Multiple Choice Questions (MCQ) on lock based protocols with choices lock-point two-phase locking protocol, deadlock two-phase locking protocol, strict two-phase locking protocol, and rigorous two-phase locking protocol for top online computer science programs. Practice lock based protocols quiz questions for merit scholarship test and certificate programs for BSc computer science.

MCQs on Lock Based Protocols PDF Download eBook

MCQ: A two-phase locking protocol variant that requires that all locks be held until the transaction commit is called

  1. Lock-point two-phase locking protocol
  2. Deadlock two-phase locking protocol
  3. Strict two-phase locking protocol
  4. Rigorous two-phase locking protocol

D

MCQ: Cascading rollbacks can be avoided by

  1. Strict two-phase locking protocol
  2. Rigorous two-phase locking protocol
  3. Deadlock two-phase locking protocol
  4. Lock-point two-phase locking protocol

A

MCQ: A process known to receive messages from transactions and in response send messages, is

  1. Recovery manager
  2. Lock manager
  3. Process manager
  4. Database administrator

B

MCQ: The two modes of locking a data item, are termed as 'shared' and

  1. Composite
  2. Compatible
  3. Exclusive
  4. Linear

C

MCQ: Two-phase locking does not ensure freedom from

  1. Obtain locks
  2. Release locks
  3. New locks
  4. Deadlocks

D