Q: Which ACID property ensures that a transaction is either fully completed or fully rolled back in case of a failure?  

Answer: A

Atomicity is the ACID property that ensures that a transaction is either fully completed or fully rolled back in case of a failure. It guarantees that all the changes made by the transaction are either applied to the database or none of them are applied.

Click me to Read more Question & Answer of Transactions and ACID properties - MySQL

---

Share this MCQ