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 different types of database?

498


What is compound key?

554


What is the sql 'in' clause?

512


What is the meaning of flat file database?

485


Explain the different types of languages that are available in the dbms?

504






Define transaction and transaction isolation levels?

552


IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

1751


How do you notify dbpak about stored procedure?

483


Compare a hierarchical and network database model?

471


Discuss some of the techniques that can be used to tune operational performance.

550


What is system r?

499


What is 3nf in the dbms?

508


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

1986


How can we tune a oracle database if log file sync issue comes

1678


what is storage manager?

539