QuizzesIntroduction to Database Transactions & Isolation Levels
beginner
databases

Introduction to Database Transactions & Isolation Levels

A beginner's quiz on the fundamentals of database transactions and isolation levels.

15 minutes 15 questions Pass at 70%
Time Limit
15 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

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. 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. 2.Which of the following is NOT a property of a database transaction?

    • AScalability
    • BAtomicity
    • CConsistency
    • DDurability
  3. 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. 4.Which isolation level allows a transaction to see uncommitted changes made by other transactions?

    • ASerializable
    • BRead Uncommitted
    • CRepeatable Read
    • DRead Committed
  5. 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. 6.Which isolation level prevents dirty reads but allows non-repeatable reads?

    • ARepeatable Read
    • BRead Uncommitted
    • CRead Committed
    • DSerializable
  7. 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. 8.Which isolation level provides the highest level of isolation?

    • ARead Uncommitted
    • BSerializable
    • CRepeatable Read
    • DRead Committed
  9. 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. 10.Which SQL command is used to start a transaction?

    • ASTART
    • BBEGIN
    • CINITIATE
    • DOPEN
  11. 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. 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. 13.Which isolation level allows non-repeatable reads but prevents dirty reads?

    • ARead Uncommitted
    • BSerializable
    • CRead Committed
    • DRepeatable Read
  14. 14.What is the main advantage of using transactions in a database?

    • AReduced storage space
    • BEnsured data integrity
    • CSimplified queries
    • DImproved performance
  15. 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