What are ACID properties?

Answer Posted / sagar

Atomicity: is an all-or-none proposition.

Consistency: guarantees that a transaction never leaves your
database in a half-finished state.

Isolation: keeps transactions separated from each other
until they’re finished.

Durability: guarantees that the database will keep track of
pending changes in such a way that the server can recover
from an abnormal termination.

Above four rules are very important for any developers
dealing with databases.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define transaction and transaction isolation levels?

542


What are the characteristics of dbms?

502


Explain armstrong rules? How they are complete and/or sound?

486


What is the purpose of a field in a database?

449


Which software is best for database?

469






What do you understand by database triggers?

500


Why do we use databases?

468


I want to export the data date to date from oracle database then what can i do?

1978


How is a database related to a table?

483


Does google have a database like access?

478


Explain the term generalization.

516


What is the main purpose of triggers in database?

447


What are the four types of database?

488


What is the purpose of database?

472


Name the different data models that are available for database systems.

464