Match each of the four ACID properties with the scenario that most clearly violates it more than it violates any other p

[answerhappygod]

Match Each Of The Four Acid Properties With The Scenario That Most Clearly Violates It More Than It Violates Any Other P 1 (78.82 KiB) Viewed 28 times

Match each of the four ACID properties with the scenario that most clearly violates it more than it violates any other properties. ···· Atomicity Isolation Consistency Durability 1. As one transaction executes, it reads the intermediate results of another partially completed transaction 2. After a hard drive failure, the database must be restored from a back-up made prior to the most recent committed transaction 3. A transaction is delayed because another transaction is currently executing 4. The power goes off in the middle of a transaction and none of the changes from that transaction are visible in the database once the power returns 5. A transaction commits a negative value for the age attribute of a tuple what has a check constraint to restrict values to the range [0,110]. 6. Two identical read-only transactions produce different results 7. A transaction in a financial database creates a new loan for a client without making an equal deposit into that client's account 8. One transaction reads a value written by another transaction before the latter was rolled back