Lock Based Protocols MCQs Quiz Online PDF Book Download

Lock based protocols multiple choice questions (MCQs), lock based protocols quiz answers to learn CS courses for online data analyst degree. Concurrency control MCQs with answers, lock based protocols quiz questions and answers for online computer programming degree. Learn multiple granularity locking, concurrency in index structures, deadlock handling, lock based protocols test prep for big data certification.

Learn concurrency control test MCQs: a two-phase locking protocol variant that requires that all locks be held until transaction commit is called, 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 online computer programming degree. Practice merit scholarships assessment test, online learning lock based protocols quiz questions for competitive assessment in computer science major .

MCQ on Lock Based Protocols Quiz Book Download

MCQ: A two-phase locking protocol variant that requires that all locks be held until 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: 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