87.2k views
1 vote
Properties of sql databases help ensure the integrity of data in the database. true or false?

User Xieyi
by
7.3k points

1 Answer

6 votes

True,

The acid property of SQL databases helps to ensure the integrity of data in the database

ACID stands for

A-Atomicity:

A transaction is intact and is either fully completed or fully rolled back.

C-Consistency:

The data should be consistent before and after the transaction.

I-Isolation:

Every transaction should achieve isolation so that they don't interfere with each other.

D-Durability :

Durability checks that once a transaction is committed, it will endure even in the event of a power outage, hardware failure, or any other system error.

User HeyThereLameMan
by
6.9k points