Transactions Flashcards

1
Q

What are the ACID Properties?

A

Atomicity

Consistency

Isolation

Durability

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

Atomicity

A

Either all operations of the transaction are properly reflected in the databases or none are (All or nothing)

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

Consistency

A

Execution of a transaction preserves the consistency of the database

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

Isolation

A

If multiple transactions occur, each one must be unaware of other executing transactions

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

Durability

A

After a successful transaction, the changes made to the database persist.. even if there are system failures

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