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.