Concurrency Control Multiple Choice Questions and Answers 1 PDF Book Download

Concurrency control multiple choice questions (MCQs), concurrency control test prep to learn dbms quiz 1 for CS degree free online courses. Learn deadlock handling multiple choice questions (MCQs), concurrency control quiz questions and answers. Free e-learning tutorial on deadlock handling, multiple granularity in dbms, concurrency in index structures test prep for SQL server certification.

Practice concurrency control career test with multiple choice question: an approach named lock timeouts is used for, for computer science majors with options deadlock elimination, deadlock detection, deadlock recovery, deadlock prevention for online IT degree programs. Professional skills assessment test with learning online deadlock handling quiz questions with dbms MCQs for IT certifications competitive exam prep.

MCQ on Concurrency Control Test 1Quiz Book Download

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 the 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