An ACID transaction secures that either all changes are successfully committed or rollbacked. It makes sure you never end in an inconsistent state.
There is different concurrency control that, for example, guarantees consistency between reads and writes. Each Table has other implementations and features here.
ACID (Atomicity, Consistency, Isolation, Durability)** transaction capabilities,