• Post Reply Bookmark Topic Watch Topic
  • New Topic

Isolation Level Quiz

 
Ray Ye
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which one of the following phenomena is NOT addressed by read-consistency?
a Phantom read
b Cached read
c Dirty read
d Non-repeatable read
e Fuzzy read

Is read-consistency equivalent to repeatable read? If that is the case, I think a would be right? Any other opinions?

Thanks,
 
Ray Ye
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
anyone on this?
 
ckm supraja
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All these issues can be solved by TRANSACTION_SERIALIZABLE
 
There is no beard big enough to make me comfortable enough with my masculinity to wear pink. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!