Computer Science Degrees Online Courses

Database Systems MCQs

Database Systems MCQs - Subtopic

Multiple Granularity Locking MCQ with Answers PDF

Practice Multiple Granularity Locking Multiple Choice Questions (MCQ), database systems quiz answers PDF with live worksheets for online degrees. Solve concurrency control Multiple Choice Questions and Answers (MCQs), Multiple Granularity Locking quiz questions and answers for master's degree in computer science. "Multiple Granularity Locking MCQ" PDF Download: concurrency in index structures, multiple granularity in dbms, deadlock handling test prep for online computer engineering programs.

"The multiple-granularity locking protocol uses multiple lock modes to ensure" Multiple Choice Questions (MCQ) on multiple granularity locking with choices sequence, serializability, deadlocks, and locking for master's degree in computer science. Learn multiple granularity locking quiz questions for merit scholarship test and certificate programs for computer information science.

MCQs on Multiple Granularity Locking

1.

The multiple-granularity locking protocol uses multiple lock modes to ensure

Sequence
Serializability
Deadlocks
Locking

2.

A set of rules applied over a transaction that may lock and unlock each of the data items in the database, is known to be

Unlocking protocol
Locking protocol
Deadlock protocol
Validation protocol

3.

A protocol that permits a transaction to lock a new data item only if it has not yet unlocked any data item, is called

Two-phase unlocking protocol
One-phase locking protocol
Two-phase locking protocol
One-phase unlocking protocol

4.

Exclusive locks are released at the end of the transaction to ensure

Recoverability
Cascadelessness
Key-value locking
Both A and B

5.

Various concurrency-control schemes are used to ensure

Serializability
Deadlock prevention
Timeouts
Locking states
Download Free Apps: