Multiple Granularity Locking MCQs Quiz Online PDF Download

Multiple granularity locking MCQs, learn database management system online test prep for distance education, online courses. Practice concurrency control multiple choice questions (MCQs), multiple granularity locking quiz questions and answers. ETS GRE test prep on concurrency in index structures, multiple granularity in dbms, deadlock handling tutorials for online distributed database system courses distance learning.

Study bachelors and masters in data science degree MCQs, multiple-granularity locking protocol uses multiple lock modes to ensure, for free online courses with choices sequence , serializability , deadlocks, locking with online teacher help resources with study tests for teaching jobs and teaching strategies. Free skills assessment test is for online learning multiple granularity locking quiz questions with MCQs, exam preparation questions and answers.

MCQs on Multiple Granularity Locking Quiz PDF 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