Explain why SNAPSHOT-isolated schedules do not exhibit dirty reads, dirty writes, lost updates, nonrepeatable reads, and phantoms.
What will be an ideal response?
Dirty Reads: Reads only committed values.
Dirty Writes: First committer wins.
Lost Updates: First committer wins
Non-Repeatable Reads: Always returns items from same snapshot
Phantoms: Always returns items from same snapshot (but note discussion in text).
Computer Science & Information Technology
You might also like to view...
Which query criteria are equivalent to "Marketing" ?
A. "marketing" B. "MARKETING" C. "mArKeTiNg" D. All of the above
Computer Science & Information Technology
The ____________________ element in HTML5 allows you to convert images into animated objects.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology