Explain ACID rule of thumb for transactions

Question

What is ACID in database transaction ? Explain.

Answer 1

ACID stands for the following principles:

A:Atomic: Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions)

C:Consistent: data is either committed or roll back no in-between case where something has been updated and something has not.

I:Isolated: no transaction sees the intermediate results of the current transaction

D:Durable: the values persist if the data had been committed even if the system crashes right after.