Master In Computer Science

Database Systems MCQs

CS: Database Systems MCQs - Subtopic

Lock Based Protocols MCQ with Answers

Lock Based Protocols Multiple Choice Questions (MCQ) to practice lock based protocols quiz answers PDF, lock based protocols worksheets for online degrees. Solve concurrency control Multiple Choice Questions and Answers (MCQs), "Lock Based Protocols Quiz Questions" and answers for top online computer science programs. Learn concurrency in index structures, multiple granularity in dbms, deadlock handling test prep for master's degree in computer science.

"A two-phase locking protocol variant that requires that all locks be held until the transaction commit is called" Multiple Choice Questions (MCQ) on lock based protocols with choices lock-point two-phase locking protocol, deadlock two-phase locking protocol, strict two-phase locking protocol, and rigorous two-phase locking protocol for top online computer science programs. Solve lock based protocols quiz questions for merit scholarship test and certificate programs for BSc computer science.

MCQs on Lock Based Protocols

1.

A two-phase locking protocol variant that requires that all locks be held until the transaction commit is called

Lock-point two-phase locking protocol
Deadlock two-phase locking protocol
Strict two-phase locking protocol
Rigorous two-phase locking protocol

2.

Cascading rollbacks can be avoided by

Strict two-phase locking protocol
Rigorous two-phase locking protocol
Deadlock two-phase locking protocol
Lock-point two-phase locking protocol

3.

A process known to receive messages from transactions and in response send messages, is

Recovery manager
Lock manager
Process manager
Database administrator

4.

The two modes of locking a data item, are termed as 'shared' and

Composite
Compatible
Exclusive
Linear

5.

Two-phase locking does not ensure freedom from

Obtain locks
Release locks
New locks
Deadlocks