Sign In
Ask Question
Jaquan Estrada
Computers & Technology
18 October, 15:43
What is dirty read and how can this be avoided?
+2
Answers (
1
)
Eve Marks
18 October, 16:00
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.
Comment
Complaint
Link
Know the Answer?
Answer
Not Sure About the Answer?
Find an answer to your question 👍
“What is dirty read and how can this be avoided? ...”
in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
What method did researchers John Mihelich and John Papineau use to study Parrotheads? a. Survey b. Experiment c. Web Ethnography d. Case study
Answers (1)
Executives of a company deal less with details of the operational activities and deal more with the higher meaningful aggregations of information or "coarser" information. What refers to the level of detail in the model? 1. Drill-down 2.
Answers (1)
Does anyone know the answer to 2 and 3
Answers (1)
The limit for characters in modern file systems is too small to accommodate keywords in titles (true or false?)
Answers (1)
Which type of recovery site is a place where computers, devices, and connectivity necessary to rebuild a network exist, with some pieces? appropriately configured, updated, or connected?/?
Answers (1)
New Questions in Computers & Technology
If you commit retail theft your drivers license will be? A. Revoked, B. Suspended, C. Cancelled or D. Restricted
Answers (1)
What feature of Excel allows you to automatically calculate common formulas with selected data? A. Orientation B. Conditional Formatting C. Custom Sort D. Quick Analysis
Answers (2)
Extraction, Transformation, and Loading (ETL) is an important component of Group of answer choices Creating a star model. Normalizing relational databases. Denormalization. Sourcing data from OLTP sources and cleansing.
Answers (1)
How do you get a free iphone without paying over 100 dollars?
Answers (2)
How do i transfer contacts from one phone to another?
Answers (1)
Home
»
Computers & Technology
» What is dirty read and how can this be avoided?
Sign In
Sign Up
Forgot Password?