Multiple Granularity Locking MCQs Quiz Online PDF Book Download

Multiple granularity locking multiple choice questions (MCQs), multiple granularity locking quiz answers to learn data analytics online courses. Concurrency control MCQs, multiple granularity locking quiz questions and answers for online MS degree in computer science. Learn lock based protocols, multiple granularity in dbms, deadlock handling, multiple granularity locking test prep for data analytics certification.

Learn concurrency control test MCQs: multiple-granularity locking protocol uses multiple lock modes to ensure, with choices sequence, serializability, deadlocks, and locking for online MS degree in computer science. Practice merit scholarships assessment test, online learning multiple granularity locking quiz questions for competitive assessment in computer science major for data analytics certification.

MCQ on Multiple Granularity Locking Quiz Book Download

MCQ: Multiple-granularity locking protocol uses multiple lock modes to ensure

  1. Sequence
  2. Serializability
  3. Deadlocks
  4. Locking

B

MCQ: A set of rules applied over a transaction that may lock and unlock each of data items in database, is known to be

  1. Unlocking protocol
  2. Locking protocol
  3. Deadlock protocol
  4. Validation protocol

B

MCQ: A protocol that permits a transaction to lock a new data item only if it has not yet unlocked any data item, is called

  1. Two-phase unlocking protocol
  2. One-phase locking protocol
  3. Two-phase locking protocol
  4. One-phase unlocking protocol

C

MCQ: Exclusive locks are released at end of transaction to ensure

  1. Recoverability
  2. Cascadelessness
  3. Key-value locking
  4. Both A and B

D

MCQ: Various concurrency-control schemes are used to ensure

  1. Serializability
  2. Deadlock prevention
  3. Timeouts
  4. Locking states

A