What is a database transaction?

A transaction is a sequence of database operations executed as a single logical unit of work. It either completes entirely (commits) or has no effect (rolls back). Example: bank transfer debits one account and credits another - both must succeed or neither should. Transactions are controlled with BEGIN, COMMIT, and ROLLBACK statements. They ensure data consistency even with concurrent access and system failures.