What do you understand by ACID?

- ACID (Atomicity Consistency Isolation Durability) is a quality sought after in a reliable database. Here's the relevance of each quality:

- Atomicity - It's an all-or-none proposition.

- Consistency - it ensures that your database is never left by a transaction in a half-finished state.

- Isolation - it keeps transactions separated from each other until they're finished.

- Durability - it ensures that database keeps a track of pending changes in a way that server can recover from an abnormal termination.