Multiple Granularity in DBMS MCQs Quiz Online PDF Book Download

Multiple granularity in dbms multiple choice questions (MCQs), multiple granularity in dbms quiz answers to learn database online courses. Concurrency control MCQs, multiple granularity in dbms quiz questions and answers for online colleges for information technology degree. Learn multiple granularity locking, lock based protocols, concurrency in index structures, multiple granularity in dbms test prep for data analytics certification.

Learn concurrency control MCQ: rigorous two-phase locking protocol permits releasing all locks at the, with choices beginning of transaction, during execution of transaction, end of transaction, and never in the life-time of transaction for online colleges for information technology degree. Practice merit scholarships assessment test, online learning multiple granularity in dbms quiz questions for competitive exams in computer science major .

MCQs on Multiple Granularity in DBMS PDF Book Download

MCQ: 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, 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 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