Computer Science Online Courses

Database Systems MCQs

Database Systems MCQ PDF - Topics

Lock Based Protocols MCQ Quiz Online

Learn Lock Based Protocols Multiple Choice Questions (MCQ), Lock Based Protocols quiz answers PDF to study database systems online course for database systems classes. Concurrency Control Multiple Choice Questions and Answers (MCQs), Lock Based Protocols quiz questions for top online computer science programs. "Lock Based Protocols MCQ" PDF Book: 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: 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. Study 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

More Topics from Database Systems Course

Download Free Apps

Database Management System App

Download Database Management System App

9th Grade Chemistry App

Download 9th Grade Chemistry App

Operating Systems App

Download Operating Systems App

Advance Electromagnetic Theory App

Download Advance Electromagnetic Theory App