ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!
  • google app store apple app store
    • тЬЦ

      Question

      Which SQL isolation level allows phantom reads but

      prevents dirty reads and non-repeatable reads?
      A Read Uncommitted Correct Answer Incorrect Answer
      B Read Committed Correct Answer Incorrect Answer
      C Repeatable Read Correct Answer Incorrect Answer
      D Serializable Correct Answer Incorrect Answer
      E Snapshot Isolation Correct Answer Incorrect Answer

      Solution

      Read Committed prevents dirty reads (only committed data read) but allows non-repeatable reads and phantoms; Repeatable Read prevents non-repeatables but can allow phantoms in some systems.

      Practice Next
      More IT DBMS Questions
      ask-question