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

What are the importance of partitioning in dbms?

612


Which database is best for storing images?

563


Can I use google sheets as a database?

529


Explain the terms specialization and generalization.

597


How a Store Procedure called with a cursor out parameter.?

628






What are different type of normalization?

621


what are the two integrity rules used in DBMS?

716


Mention some disadvantages of query?

611


What are foreign keys in database?

555


Why is database used?

571


Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?

571


Explain about the properties of cursors?

590


How to load a file into database column?

593


What is the best free database?

594


Define truncate and delete commands?

604