Home > Databases > Quizzes > RDBMS Basics Practice Test: Transactions
RDBMS Basics Practice Test: Transactions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 82% • Most missed: “If a schedule is equivalent to a serial schedule, it is called as a _________”
Quiz on transaction concept, serializability, transaction isolation and its levels. RDBMS transactions are a feature of relational database management systems (RDBMS) that allow users to group multiple SQL statements together. With a transaction-aware RDBMS, users can start a transaction, perform actions, and either commit the results to the database or roll back all of their SQL statements.  Here are some aspects of RDBMS transactions: Concurrency control: A critical aspect of RDBMS that ensures that multiple transactions accessing the same data can execute concurrently without producing... Show more
RDBMS Basics Practice Test: Transactions
Time left 00:00
25 Questions

1. If I = read(Q) and J = write(Q) then the order of I and J does not matter.
2. The scheme that controls the interaction between executing transactions is called as _____
3. In ___________ isolation each transaction is given its own version of the database
4. Which of the following systems is responsible for ensuring isolation?
5. The phenomenon in which one failure leads to a series of transaction rollbacks is called as ________
6. Which of the following is a property of transactions?
7. Serializable level may allow both serializable and non-serializable executions
8. A transaction that has not been completed successfully is called as _______
9. ___________ allows uncommitted data to be read
10. ________ allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction.
11. Transactions can only run serially
12. A ___________ is one where, for each pair of transactions Ti and Tj such that Tj reads a data item previously written by Ti , the commit operation of Ti appears before the commit operation of Tj
13. Which of the following is not a property of a transaction?
14. Collections of operations that form a single logical unit of work are called __________
15. What is the disadvantage of locking?
16. A ___________of the transactions can be obtained by finding a linear order consistent with the partial order of the precedence graph.
17. If a schedule is equivalent to a serial schedule, it is called as a _________
18. If a schedule S can be transformed into a schedule S’ by a series of swaps of non-conflicting instructions, then S and S’ are
19. The “all-or-none” property is commonly referred to as _________
20. ________ allows only committed data to be read, but does not require repeatable reads
21. Which of the following is the most expensive method?
22. Information residing in the volatile storage does not usually survive system crashes
23. Which of the following is a transaction isolation level as specified by SQL standard?
24. When is a timestamp allotted
25. The set of ________ in a precedence graph consists of all the transactions participating in the schedule

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