Question : What is ACID Properties in SQL Database ?
- A-> Atomicity: all the transaction in database should be atomic. it means that all the transaction step should be executed or whole transaction can be rolled back. C-> Consistency: this is spoken in terms of consistency. if there is any write written, then the read just after that should get the right data. data should not be stale data and it should be consistent. I-> Isolation: Multiple transactions should happen independently across the database without interfering with other transactions. D-> Durability: the changes occurs in the database are successful even if there is system failure or error occurs