ACID Flashcards

(4 cards)

1
Q

A

A

Atomicity (“all or nothing”)
If something goes wrong → rollback.

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

C

A

Consistency (“rules stay true”)
Database goes from one valid state to another.

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

I

A

Isolation (“transactions don’t interfere”)
No dirty reads, no interference.

This is where locking and serialisability live.

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

D

A

Durability (“once done, stays done”)
Committed = permanent.

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