Read Uncommitted (Dirty Reads)

Problem

You are explaining transaction isolation levels. In Read Uncommitted, transactions can read data that has been modified by another transaction but not yet committed. Write a query that outputs problem with the value: "Dirty reads occur when a transaction reads uncommitted changes from another transaction that may eventually roll back."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution