Exercise 1:
-
Explain the CAP theorem with an example scenario.
-
Why can’t a distributed database system achieve all three: Consistency, Availability, and Partition Tolerance at the same time?
-
Provide a real-world example of a database that prioritizes:
-
(a) CA (Consistency + Availability).
-
(b) CP (Consistency + Partition Tolerance).
-
(c) AP (Availability + Partition Tolerance).
Exercise 2:
Complete the sentences by writing the correct ACID property:
-
______________ guarantees that the database moves from one valid state to another after a transaction.
-
______________ ensures that transactions are executed independently, even when run concurrently.
-
______________ ensures that once a transaction is committed, its changes will persist even in the case of a crash.
-
ensures that either all steps in a transaction are completed or none at all.
