Question

A _____ occurs when one transaction reads data written by another transaction before the other transaction commits. dirty read lost column value collision uncommitted dependency

Answer 1

Answer: dirty read, uncommitted dependency

Explanation:

We have this problem of dirty read when we have many transactions running simultaneously and then one transaction reads a value which has not been committed by another transaction. If such a situation arises then it leads to problems as when it results in redundancy of data and we get a wrong result.

Uncommitted dependency also happens in this way by which it reads the value from a transaction which is in its intermediate stage.

The uncommitted value of the transaction is called as the dirty data and leads to redundancy in the final outcome of the transaction.