Avoidable conditions in Isolation level

Question

What are the conditions in Isolation level ignored?

Answer 1

It is essential to avoidable conditions in Isolation level as follows:

• Lost updates: while two transactions read similar data.

• Dirty read- Arises while a transaction reads data which has not been updated.

• Non repeatable reads- arise when various results are read multiple times.

• Phantoms- Arises while row data matches the first time if does not match following times.