| CARVIEW |
- Courses
- Tutorials
- Practice
- Jobs
Concurrency Control Techniques and Lock-Based Protocols Quiz
Quiz on Concurrency Control Techniques and Lock-Based Protocols
Question 1
Which of the following is a disadvantage of locking each data item individually in concurrency control?
Increased data integrity
Reduced deadlocks
Higher overhead
Faster transaction execution
Question 2
What are the two phases in the Two-Phase Locking (2PL) protocol?
Read and Write
Locking and Unlocking
Growing and Shrinking
Active and Passive
Question 3
Which type of 2PL ensures that transactions hold all their exclusive(write) locks until they commit?
Basic 2PL
Conservative 2PL
Rigorous 2PL
Strict 2PL
Question 4
What is the main aim of concurrency control in DBMS?
Increase disk I/O
Improve CPU usage
Maintain data consistency
Reduce memory usage
Question 5
Which concurrency control technique is based on the assumption that conflicts are rare?
Lock-based
Timestamp ordering
Optimistic concurrency control
Rigorous 2PL
Question 6
Which protocol avoids deadlocks by locking all data items before a transaction begins?
Basic 2PL
Rigorous 2PL
Conservative 2PL
Timestamp protocol
Question 7
Which of the following is true for Rigorous 2PL?
Only shared locks are held till commit
Exclusive locks are released early
All locks (shared and exclusive) are held till commit
It allows unlocking in the growing phase
Question 8
What is the key problem that Two-Phase Locking helps prevent?
Data redundancy
Disk fragmentation
Non-serializable schedules
Indexing errors
Question 9
What does a transaction do in the shrinking phase of 2PL?
Acquire new locks
Release held locks
Read data items
Write to logs
Question 10
Why does the lock-based protocol potentially lead to deadlocks?
It uses timestamps
It releases all locks at once
Transactions wait indefinitely for locks
It only uses optimistic assumptions
There are 10 questions to complete.
