Computer Science Courses Online

Database Systems MCQs

Database Systems MCQ Questions - Topic

Lock Based Protocols MCQ with Answers PDF

Lock Based Protocols Multiple Choice Questions (MCQ), Lock Based Protocols quiz answers PDF with database systems live worksheets for online degrees. Solve concurrency control Multiple Choice Questions and Answers (MCQs), Lock Based Protocols quiz questions for top online computer science programs. Lock Based Protocols Interview Questions PDF: 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" MCQ PDF 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 Quiz

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

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

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

Recovery manager
Lock manager
Process manager
Database administrator

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

Composite
Compatible
Exclusive
Linear

MCQ: Two-phase locking does not ensure freedom from

Obtain locks
Release locks
New locks
Deadlocks