Concurrency in Index Structures MCQs Quiz Online PDF Download

Learn concurrency in index structures MCQs, database management system test for learning online courses and test prep to practice. Concurrency control quiz has multiple choice questions (MCQ), concurrency in index structures quiz questions and answers, multiple granularity in dbms, concurrency in index structures tutorials for online Microsoft SQL courses distance learning.

Database management system practice test MCQ: system must deal with deadlocks that are not prevented by using schemes of with choices validation , deadlock detection , deadlock recovery and both a and b with online distance learning for masters in computer science degree courses. Free study guide is for online learning concurrency in index structures quiz with MCQs to practice test questions with answers.

MCQs on Concurrency in Index Structures Quiz PDF Download

MCQ. System must deal with deadlocks that are not prevented by using schemes of

  1. Validation
  2. Deadlock detection
  3. Deadlock recovery
  4. Both A and B


MCQ. A scheme that creates a new version of a data item for each transaction is defined by

  1. Concurrency control scheme
  2. Multiversion concurrency control scheme
  3. Timestamp concurrency control scheme
  4. Wound concurrency control scheme


MCQ. A transaction that is inserting a new tuple into database is given an

  1. Shared lock
  2. Mutual lock
  3. Exclusive lock
  4. NO lock


MCQ. Concurrency control is a challenging task for transactions that have

  1. Application accesses
  2. I/O activities
  3. User interactions
  4. Application interactions


MCQ. In preemption technique, transactions are assigned a unique timestamp to decide whether it should wait or

  1. Executed
  2. Committed
  3. Aborted
  4. Rolled back