Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

  • A.Nonrepeatable read
  • B.
    Phantom read
  • C.Dirty read
  • D.Consistent read

Answer: C

Correct answer: Dirty read

A dirty read is reading data that another transaction has changed but not yet committed. If that transaction subsequently rolls back, the value read never existed in the database at all, and any decision taken on it is unfounded. Only the read uncommitted isolation level permits it.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.