Multiple Granularity in DBMS MCQs Quiz Online PDF Download

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

Study bachelors and masters in data science degree MCQs, rigorous two-phase locking protocol permits releasing all locks at the, for free online courses with choices beginning of transaction, during execution of transaction, end of transaction, never in the life-time of transaction for online learning for bachelor's degree and masters degree distance learning exams. Free skills assessment test is for online learning multiple granularity in dbms quiz questions with MCQs, exam preparation questions and answers.

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