Computer Science Degrees Online Courses

Database Systems MCQ Questions

Database Systems MCQs - Chapter

Concurrency Control Multiple Choice Questions and Answers PDF p. 1

Practice Concurrency Control multiple choice questions and answers, CS quiz answers PDF to solve dbms test 1 for online certification. Solve deadlock handling MCQs, Concurrency Control Trivia Questions and answers for admission and merit scholarships test. "Concurrency Control MCQ" PDF book: 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 (MCQ) on concurrency control with choices deadlock elimination, deadlock detection, deadlock prevention, and deadlock recovery for 2 year computer science degree. Practice deadlock handling quiz questions for jobs' assessment test and online courses for jobs' assessment test and online courses for CS major.

MCQs on Concurrency Control Quiz

1.

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

Deadlock detection
Deadlock elimination
Deadlock prevention
Deadlock recovery

2.

An approach named Lock timeouts is used for

Deadlock detection
Deadlock elimination
Deadlock recovery
Deadlock prevention

3.

The rigorous two-phase locking protocol permits releasing all locks at the

Beginning of transaction
During execution of transaction
End of transaction
Never in the life-time of transaction

4.

The system must deal with the deadlocks that are not prevented by using schemes of

Validation
Deadlock detection
Deadlock recovery
Both A and B

5.

A scheme that creates a new version of a data item for each transaction is defined by

Concurrency control scheme
Multiversion concurrency control scheme
Timestamp concurrency control scheme
Wound concurrency control scheme