Ask Question
29 February, 07:31

What is dirty read and how can this be avoided?

+4
Answers (1)
  1. 29 February, 09:56
    0
    Answer and Explanation:

    Uncommitted dependency usually called as Dirty read can be explained as a situation in which a transaction reads the value from a row that has been modified by another uncommitted transaction, and is in running.

    Second transaction needs not necessarily be committed transaction in order for the initial query to return a varying result. This situation is similar to the non - repeatable reads.

    Out of order appearance of the levels in the results is the only thing in the isolation of the uncommitted read which can be prevented such that earlier updates will always show up first in the result.

    The dirty read can be avoided by the Read Committed isolation level of the four levels of SQL which ensures the non issuance of the shared (read) to any other transaction thus making it dirty read free.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “What is dirty read and how can this be avoided? ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers