ACID Flashcards

1
Q

What is ACID

A

ACID stands for Atomicity, Consistency, Isolation, Durability. It is used to ensure that the data transactions are processed reliably in a database system.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Atomicity

A

Atomicity refers to the transactions that are completely done or failed where transaction refers to a single logical operation of a data. It means if one part of any transaction fails, the entire transaction fails and the database state is left unchanged.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Consistency

A

Consistency ensures that the data must meet all the validation rules. In simple words, you can say that your transaction never leaves the database without completing its state.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Isolation

A

The main goal of isolation is concurrency control.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Durability

A

Durability means that if a transaction has been committed, it will occur whatever may come in between such as power loss, crash or any sort of error.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly