What is ACID property?

Answer Posted / imran badrampalli

ACID (an acronymn for Atomicity Consistency Isolation
Durability) is a concept that Database Professionals
generally look for when evaluating databases and
application architectures. For a reliable database all this
four attributes should be achieved.

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 ?    41 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Never found uncombined on earth, what element occurs abundantly in limestone, gypsum and fluorite?

575


What is the molar mass of chlorine?

642


The use of electricity to decompose molten sodium chloride into its component elements is an example of?

572


Fish in an aquarium require oxygen to live, which is usually done by pumping air into the fish tank using a mechanical pump. If all other things remain constant, the most effective transfer of oxygen to water comes from?

560


Carbohydrates are made of what three elements?

597






How do you solve ideal gas law problems?

622


How do you extract ephedrine from a mineral block?

657


What are the advantages of infrared technology?

600


I have source having single column C1 RAM KRISHNA I have to load that data in to one target . that target contain two columns C1 and C2 I want the out put like C1 C2 RAM KRISHNA that means in 1st column RAM and Second column Krishna ok by using informatica only . single space in between ram krishna in soucre column ok?

2700


How do you separate the colors of ink?

608


What is message oriented middleware (mom) in client server environment?

592


What is a substituted hydrocarbon?

576


Two common isotopes of carbon are carbon-12 and carbon-14. How are atoms of the isotopes different from one another?

527


What is ciprofloxacin hcl used for what type?

570


Knowing that iron has an atomic number of 26, how many protons and how many electrons does fe+2 have?

609