Thread: Isolation Levels in SQL

I am learning the database language SQL. I want to know the isolation levels in SQL.
Any help would be highly appericated…

1) There are four isolation levels in SQL

• READ UNCOMMITTED

• READ COMMITTED

• REPEATABLE READ

• SERIALIZABLE

2) Isolation level is use to thwart the subsequent problems:

1. Lost Updates

2. Dirty Reads

3. Nonrepeatable Reads

4. Phantoms