Databases

Question 1

When referring to databases, what does it mean to be ACID-compliant?

Answer 1

Database operations that adhere to the properties of Atomicity, Consistency, Isolation, and Durability

Question 2

What does it mean for database operations to adhere to Atomicity properties?

Answer 2

A transaction is treated as a single, indivisible unit of work; either all changes within the transaction are committed, or none are.

Question 3

What does it mean for database operations to adhere to Consistency properties?

Answer 3

The database remains in a valid state after each transaction, meaning that all data constraints and rules are followed.

Question 4

What does it mean for database operations to adhere to Isolation properties?

Answer 4

Transactions are executed independently, preventing interference or conflicts between concurrent transactions.

Question 5

What does it mean for database operations to adhere to Durability properties?

Answer 5

Once a transaction is committed, the changes are permanently stored and survive system failures or crashes.