BS & MS In Computer Science

Database Systems MCQs

Database Systems MCQ Questions - Topic

Multiple Granularity Locking MCQ with Answers PDF

Multiple Granularity Locking Multiple Choice Questions (MCQ), Multiple Granularity Locking quiz answers PDF to study database systems online course for database systems classes. Concurrency Control Multiple Choice Questions and Answers (MCQs), Multiple Granularity Locking quiz questions for master's degree in computer science. "Multiple Granularity Locking " Book PDF: 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" MCQ PDF: multiple granularity locking with choices sequence, serializability, deadlocks, and locking for master's degree in computer science. Study multiple granularity locking quiz questions for merit scholarship test and certificate programs for computer information science.

MCQs on Multiple Granularity Locking Quiz

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

Sequence
Serializability
Deadlocks
Locking

MCQ: 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

MCQ: 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

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

Recoverability
Cascadelessness
Key-value locking
Both A and B

MCQ: Various concurrency-control schemes are used to ensure

Serializability
Deadlock prevention
Timeouts
Locking states