► All SQL statements always work with a snapshot of the database to provide data consistency.

► For READ WRITE transactions, the snapshot is taken when each statement starts.

► For READ ONLY transactions, the snapshot is taken when the transaction starts.

► The snapshot never include uncommitted changes from other transactions.

► The snapshot always include uncommitted changes from its own transaction.