Concurrency Control Multiple Choice Questions and Answers PDF Book Download

Concurrency control Multiple Choice Questions and Answers (MCQs), concurrency control quiz answers pdf 1, dbms tests to study online certification courses. Learn deadlock handling MCQs, "concurrency control" quiz questions and answers for admission and merit scholarships test. Learn deadlock handling, multiple granularity in dbms, concurrency in index structures career test for top computer science schools in the world.

"A protocol that ensures the system will never enter a deadlock state is called" Multiple Choice Questions (MCQs) on concurrency control with choices deadlock elimination, deadlock detection, deadlock prevention, and deadlock recovery for 2 year computer science degree. Practice jobs' assessment test, online learning deadlock handling quiz questions for CS major.

MCQs on Concurrency Control Quiz 1 PDF Book Download

MCQ: A protocol that ensures the 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: The 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: The system must deal with the 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