intermediateTransactions — ACID, COMMIT, ROLLBACK, SAVEPOINT
Explain the ACID properties of a database transaction.
Atomicity: all statements in a transaction execute completely or none do. If any step fails, all previous steps in the transaction are rolled back. No partial transactions. Consistency: the database moves from one valid state to another valid state. All constraints (PK, FK, CHECK) are satisfied after commit. Isolation: concurrent transactions operate as if they were executed serially. Isolation le
Ready to master this question?
Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.
Sign in to generate a response