As an Amazon Associate I earn from qualifying purchases.

Multiple Granularity in DBMS MCQs Quiz Online PDF Download eBook

Solve Multiple Granularity in DBMS Multiple Choice Questions (MCQ), multiple granularity in dbms quiz answers PDF database practice test for online degree programs. Learn concurrency control Multiple Choice Questions and Answers (MCQs), "Multiple Granularity in DBMS Quiz" questions and answers for 2 year computer science degree. Learn lock based protocols, concurrency in index structures test prep for top computer science schools in the world.

"The rigorous two-phase locking protocol permits releasing all locks at the" Multiple Choice Questions (MCQ) on multiple granularity in dbms with choices beginning of transaction, during execution of transaction, end of transaction, and never in the life-time of transaction for 2 year computer science degree. Practice multiple granularity in dbms quiz questions for merit scholarship test and certificate programs for CS major.

MCQs on Multiple Granularity in DBMS PDF Download eBook

MCQ: The rigorous two-phase locking protocol permits releasing all locks at the

  1. Beginning of transaction
  2. During execution of transaction
  3. End of transaction
  4. Never in the life-time of transaction

C

MCQ: For deadlock prevention, when we use an ordering of data items, the request locks are sequenced in

  1. Consistent with access
  2. Consistent with relation
  3. Consistent with ordering
  4. Consistent with execution

C

MCQ: A way of guarding against deadlock prevention is to

  1. Order data items
  2. Order the execution
  3. Order access
  4. Order cascading

A

MCQ: To ensure deadlock prevention, we can use the preemption approach and

  1. Rollbacks
  2. Timestamping
  3. Cascading
  4. Validating

A

MCQ: Graph-based locking protocols impose restrictions on the

  1. Order of execution
  2. Order of access
  3. Order of evaluation
  4. Order of cascading

B