SQL Database Concepts Question:

Download Job Interview Questions and Answers PDF

Explain ACID?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

Answer:

- 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.

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
What is SQL Stored Procedure?What are SQL Dirty pages?