Q: Which ACID property ensures that a transaction's execution does not violate the defined rules and constraints of the database?  

Answer: B

Consistency is the ACID property that ensures that a transaction's execution does not violate the defined rules and constraints of the database. It guarantees that the database remains in a valid and consistent state before and after the transaction.

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

---

Share this MCQ