Question

If a transaction is successful, what must we do to ensure that the entire database sees the changes?

Answer 1

Every transaction in DBMS must maintain ACID – A (Atomicity), C (Consistency), I (Isolation), D (Durability). One must maintain ACID to ensure the completeness, accuracy, and integrity of data.