Databases — Transactional Good Practice

Question 1

Explain

What is the ACID acronym for?

Answer 1

Ensuring reliable and consistent database operations (transations).

Question 2

Recall

What does ACID stand for?

Answer 2

A: Atomicity
C: Consistency
I: Integrity
D: Durability

Question 3

Define

Transactional Atomicity

Answer 3

Ensuring that everything within a transation is committed, or nothing at all.

(e.g. if a transaction is tasked with updating A and B, and it updates A successfully and not B, revert A’s update.)

(everything is committed or nothing is committed at all.)

Question 4

Define

Transactional Isolation

Answer 4

Concurrent transactions do not interfere with each other.

Question 5

Define

Transactional Consistency

Answer 5

Every transaction must move the database from one valid state to another.

(i.e. a transaction must adhere to the databases’s rules and constraints)

Question 6

Define

Transactional Durability

Answer 6

Once a transaction is committed, its changes are persisted and can survive various system events.