Question · SQL and MySQL course · Module 10: Transactions and advanced SQL

When to use a transaction

Which situation MOST requires using a transaction?

Answer options

  • A single SELECT retrieving the titles of all books
  • Borrowing a book: the INSERT into wypozyczenia and the UPDATE of availability must happen together
  • Displaying the list of categories in the database
  • Counting how many authors there are with COUNT

You can check the correct answer by solving this task in the CodeWorlds game.