Concurrency Control Multiple Choice Questions and Answers 1 pdf eBooks Download

Learn concurrency control multiple choice questions (MCQs), db test 1 online for exams. Practice deadlock handling MCQs questions and answers on deadlock handling, multiple granularity in dbms, concurrency in index structures with answers. Free concurrency control quiz, online study guide has helping answer key with choices as deadlock elimination, deadlock detection, deadlock prevention and deadlock recovery of multiple choice questions (MCQ) as a protocol that ensures system will never enter a deadlock state is called to test learning skills for viva exam preparation and job's interview questions. Study to learn deadlock handling quiz questions to practice online MCQs for competitive exam preparation test.

MCQ on Concurrency Control Quiz pdf Download Test 1

MCQ. A protocol that ensures system will never enter a deadlock state is called

  1. Deadlock detection
  2. Deadlock elimination
  3. Deadlock prevention
  4. Deadlock recovery

C

MCQ. An approach named Lock timeouts is used for

  1. Deadlock detection
  2. Deadlock elimination
  3. Deadlock recovery
  4. Deadlock prevention

D

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 life-time of transaction

C

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