Complete the sentence to explain what a transaction is in a database.
A transaction is a sequence of operations that [1] the database from one consistent state to another.
A transaction changes the database from one consistent state to another, ensuring data integrity.
Complete the sentence to describe the property that ensures all parts of a transaction succeed or fail together.
The property that ensures a transaction is all-or-nothing is called [1].
Atomicity means the transaction is indivisible; it either fully happens or does not happen at all.
Fix the error in the sentence about transaction isolation.
Transaction isolation ensures that concurrent transactions [1] each other's intermediate states.
Isolation means transactions hide their intermediate states from others to prevent inconsistent data.
Fill both blanks to complete the explanation of the consistency property.
Consistency ensures that a transaction [1] the database from one valid state to another and [2] all defined rules.
Consistency means the database moves between valid states and follows all rules like constraints.
Fill all three blanks to complete the sentence about durability in transactions.
Durability means once a transaction is [1], its changes are [2] in the database and will [3] even if the system crashes.
Durability guarantees that committed changes are permanently saved and persist despite failures.