Home > Databases > Quizzes > DBMS Basics Practice Test: Concurrency Control
DBMS Basics Practice Test: Concurrency Control
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 76% • Most missed: “Which statements are correct regarding indexes?”
Quiz questions on deadlocks, lock based protocols, granularity, types of reads like insertion, deletion and predicate and the concept of concurrency in index structures. Concurrency control (CC) is a fundamental component of a database management system (DBMS) that ensures that multiple transactions can run simultaneously without interfering with each other or compromising the database's integrity. CC ensures that data is updated correctly when multiple transactions are executed concurrently.  CC mechanisms include: Pessimistic concurrency control: Delays transactions if they conflict with... Show more
DBMS Basics Practice Test: Concurrency Control
Time left 00:00
25 Questions

1. Which statements are correct regarding indexes?
2. Which of the following is the block that is not permitted to be written back to the disk?
3. Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
4. Lost update problem is
5. DBMS periodically suspends all processing and synchronizes its files and journals through the use of
6. __________ rollback requires the system to maintain additional information about the state of all the running transactions.
7. The _____________ ensures that any conflicting read and write operations are executed in timestamp order.
8. If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
9. _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
10. The deadlock in a set of a transaction can be determined by
11. When a transaction Ti attempts to update a data item, it requests a _________ on that data item.
12. In a granularity hierarchy the highest level represents the
13. Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seq1
NOCACHE;The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:
SELECT seq1.nextval FROM dual;
What is displayed by the SELECT statement?
14. Snapshot isolation is used to give
15. In a database the file is contained in ________
16. You executed the following SQL statements in the given order:
CREATE TABLE orders
DELETE FROM order;The DELETE statement results in the following error:
ERROR at line 1: table or view does not exist
What would be the outcome?
17. A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
18. The deadlock can be handled by
19. The deadlock state can be changed back to stable state by using _____________ statement.
20. In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?
21. A non-correlated subquery can be defined as________
22. The method of access that uses key transformation is called as
23. The __________ requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
24. A lock that allows concurrent transactions to access different rows of the same table is known as a
25. In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

⚡ 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.