(f) Transaction processing, ACID (Atomicity, Consistency, Isolation, Durability), record locking and redundancy

Question 1

What is transaction processing?

Answer 1

Executing a sequence of database operations that are treated as a single logical unit.

Question 2

What does ACID stand for?

Answer 2

Atomicity, Consistency, Isolation, Durability.

Question 3

Define Atomicity in ACID.

Answer 3

Ensures all parts of a transaction are completed or none at all.

Question 4

Define Consistency in ACID.

Answer 4

Guarantees the database remains in a valid state before and after a transaction.

Question 5

Define Isolation in ACID.

Answer 5

Prevents interference from other concurrent transactions.

Question 6

Define Durability in ACID.

Answer 6

Ensures once a transaction is committed, it remains even in a system failure.

Question 7

What is record locking?

Answer 7

A method to prevent simultaneous access to data, avoiding conflicts.

Question 8

What is data redundancy?

Answer 8

Duplication of data across the database, often avoided through normalisation.