Concurrency in Index Structures MCQs & Quiz Online PDF eBook Download

Concurrency in index structures multiple choice questions (MCQs), concurrency in index structures quiz answers to learn databases for online computer science degree programs. . Concurrency control MCQs, concurrency in index structures quiz questions and answers for online computer science engineering. Learn deadlock handling, multiple granularity locking, multiple granularity in dbms, concurrency in index structures test prep for CS major.

Learn concurrency control 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 for online computer science engineering. Practice merit scholarships assessment test, online learning concurrency in index structures quiz questions for competitive exams in computer science major for online college classes.

MCQs on Concurrency in Index Structures PDF eBook 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

D

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

B

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

C

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

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

C

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

D