Home > Databases > Quizzes > RDBMS Basics Practice Test: Concurrency Control
RDBMS Basics Practice Test: Concurrency Control
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 77% • Most missed: “How do we generally recover from a deadlock?”
Quiz on lock and timestamp based protocols, deadlock handling, multiversion schemes, validation based protocols, insert and delete operations. Concurrency control in a relational database management system (RDBMS) manages operations that happen simultaneously so that they don't conflict with each other. This ensures that data integrity is maintained when updates are made to the database in a multi-user environment Here are some concurrency control mechanisms: Optimistic concurrency control (OCC): Allows multiple transactions to read and modify the same data without locking or blocking each... Show more
RDBMS Basics Practice Test: Concurrency Control
Time left 00:00
25 Questions

1. Which of the following timestamps is used to record the time when a database has completed its write operation?
2. In timestamp ordering protocol, suppose that the transaction Ti issues write(Q) and TS(Ti)
3. If a transaction can be granted a lock on an item immediately in spite of the presence of another mode, then the two modes are said to be ________
4. If the first update is overwritten by a second, it is called as a _______ update
5. Which of the following timestamp is used to record the time at which the transaction started execution?
6. W-timestamp(Q) denotes?
7. In ________ no two aborts occur unless two concurrent transactions update the same data item.
8. Under ________ the system uses locking mechanism that applies only to updates
9. In timestamp ordering protocol, suppose that the transaction Ti issues read(Q) and TS(Ti)
10. How do we generally recover from a deadlock?
11. Which of the following transactions can multiversion two phase locking protocol not differentiate.
12. The situation where no transaction can proceed with normal execution is known as ________
13. Partial rollback is not possible.
14. A transaction is made to wait until all ________ locks held on the item are released
15. If a transaction has obtained a __________ lock, it can read but cannot write on the item
16. A system is in a _______ state if there exists a set of transactions in which every transaction is waiting for another transaction in the set.
17. Which of the following timestamps is used to record the time when a transaction has finished its read phase?
18. A transaction can proceed only after the concurrency control manager ________ the lock to the transaction
19. Which of the following steps must be taken while choosing a victim?
20. Snapshot isolation prevents lost updates
21. A logical counter is _________ after a new timestamp has been assigned
22. _________ is a form of two degree consistency designed for programs that iterate over tuples of a relation by using cursors.
23. Read only operations omit the _______ phase
24. The two phase locking protocol consists which of the following phases?
25. Which of the following is not a method in deadlock handling

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.