Q: Which ACID property ensures that concurrent execution of transactions does not result in data anomalies such as dirty reads and non-repeatable reads?
Isolation is the ACID property that ensures that concurrent execution of transactions does not result in data anomalies such as dirty reads and non-repeatable reads. It provides transactional isolation, preventing interference between concurrently executing transactions.