As an Amazon Associate I earn from qualifying purchases.

Multiple Granularity Locking MCQs Quiz Online PDF Download eBook

Solve Multiple Granularity Locking Multiple Choice Questions (MCQ), multiple granularity locking quiz answers PDF data science practice test for online courses. Learn concurrency control Multiple Choice Questions and Answers (MCQs), "Multiple Granularity Locking Quiz" questions and answers for master's degree in computer science. Learn multiple granularity in dbms, multiple granularity locking, deadlock handling test prep for online computer engineering programs.

"The multiple-granularity locking protocol uses multiple lock modes to ensure" Multiple Choice Questions (MCQ) on multiple granularity locking with choices sequence, serializability, deadlocks, and locking for master's degree in computer science. Practice multiple granularity locking quiz questions for merit scholarship test and certificate programs for computer information science.

MCQs on Multiple Granularity Locking PDF Download eBook

MCQ: The 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 the data items in the 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 the end of the 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