Answers

Question and Answer:

  Home  Basic SQL Server

⟩ Explain ACID?

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

- Atomicity is an all-or-none proposition.

- Consistency - it guarantees 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 the database keeps a track of pending changes in a way that the server can recover from an abnormal termination.

 143 views

More Questions for you: