Concurrency Control Multiple Choice Questions 1 PDF Download

Learn concurrency control multiple choice questions (MCQs), database management system test 1 for online learning, course exam prep. Practice deadlock handling MCQs, concurrency control questions and answers on deadlock handling, multiple granularity in dbms, concurrency in index structures test for online SQL server management studio courses distance learning.

Free concurrency control quiz online, self-study student guide has multiple choice question: a protocol that ensures system will never enter a deadlock state is called with choices deadlock elimination , deadlock detection , deadlock prevention and deadlock recovery for associate degree, graduate degree and masters degree students for online eLearning preparation. Study to learn online deadlock handling quiz questions with database management system MCQs for IT certifications competitive exam prep.

MCQ on Concurrency Control Test 1 Quiz PDF 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