Question: Which of the following statements about SQL transactions and ACID properties is correct?

A) The isolation property of ACID ensures that transactions can see changes made by other transactions, preventing lost updates and ensuring data consistency.
B) The durability property guarantees that once a transaction has been committed, its changes will survive system failures, ensuring that data is not lost.
C) The atomicity property ensures that all parts of a transaction are executed successfully, and if any part fails, the entire transaction is committed.
D) The consistency property guarantees that transactions can run concurrently without affecting the integrity of the database.