Introduction to Database Transactions & Isolation Levels
A beginner's quiz on the fundamentals of database transactions and isolation levels.
Questions in this quiz
15 questions on Introduction to Database Transactions & Isolation Levels. Work through them here, then start the quiz to answer them and see your score.
1.What is a database transaction?
- AA backup of the database
- BA single SQL query
- CA sequence of operations performed as a single logical unit of work
- DA type of database index
2.Which of the following is NOT a property of a database transaction?
- AScalability
- BAtomicity
- CConsistency
- DDurability
3.What does the 'Isolation' property in ACID ensure?
- AData is saved permanently after a transaction
- BData is consistent before and after the transaction
- CTransactions are completed in isolation from each other
- DAll parts of a transaction are completed or none are
4.Which isolation level allows a transaction to see uncommitted changes made by other transactions?
- ASerializable
- BRead Uncommitted
- CRepeatable Read
- DRead Committed
5.What is a 'dirty read' in the context of database transactions?
- AReading data that is being modified by another transaction
- BReading data that has been committed
- CReading data that has been rolled back
- DReading data from a backup
6.Which isolation level prevents dirty reads but allows non-repeatable reads?
- ARepeatable Read
- BRead Uncommitted
- CRead Committed
- DSerializable
7.What is a 'phantom read' in database transactions?
- AReading a row that has been updated
- BReading a row that does not exist
- CReading a row that has been deleted
- DReading a row that appears in a result set due to another transaction's insert
8.Which isolation level provides the highest level of isolation?
- ARead Uncommitted
- BSerializable
- CRepeatable Read
- DRead Committed
9.What does 'atomicity' ensure in a transaction?
- AData is consistent before and after the transaction
- BTransactions are completed in isolation from each other
- CData is saved permanently after a transaction
- DAll parts of a transaction are completed or none are
10.Which SQL command is used to start a transaction?
- ASTART
- BBEGIN
- CINITIATE
- DOPEN
11.What is the purpose of the COMMIT command in SQL?
- ATo save all changes made in the transaction
- BTo view changes made in the transaction
- CTo revert changes made in the transaction
- DTo start a transaction
12.What does the ROLLBACK command do in a transaction?
- AStarts a new transaction
- BReverts changes made in the transaction
- CEnds the transaction
- DSaves changes made in the transaction
13.Which isolation level allows non-repeatable reads but prevents dirty reads?
- ARead Uncommitted
- BSerializable
- CRead Committed
- DRepeatable Read
14.What is the main advantage of using transactions in a database?
- AReduced storage space
- BEnsured data integrity
- CSimplified queries
- DImproved performance
15.Which of the following is an example of a non-repeatable read?
- AReading a row that does not exist
- BReading a row that has been deleted
- CReading a row that has been inserted by another transaction
- DReading a row that has been updated by another transaction