📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    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