Transaction Properties

Question 1

What is a transaction?

Answer 1

A transaction is a sequence of one or more SQL statements that are executed as a single unit of work. It is either fully completed, committing changes to the database, or fully rolled back, undoing any changes.

Question 2

Give and explain the four properties of a transaction.

Answer 2

Atomicity: All changes in a transaction are applied or none at all.
Consistency: A transaction brings the database from one consistent state to another.
Isolation: The execution of one transaction is isolated from the execution of other transactions.
Durability: Once a transaction is committed, its changes persist, even in the event of system failure.