ACID

ACID is a set of properties that guarantee database transactions are processed reliably:

• Atomicity, 
• Consistency, 
• Isolation,
• Durability.

http://en.wikipedia.org/wiki/ACID

But, CAP theorem states that it is impossible for a distributed computer system to simultaneously provide all three of the following guarantees:

• Consistency,
• Availability,
• Partition tolerance.