Question

What are isolation levels and use of isolation levels?

Answer

While executing queries, SQL Server often required to acquire locks on resources to prevent dirty reads,phantom reads etc. These locking behavior will be depends on isolation levels. Based on isolation level of transaction, SQL Server will acquire locks on resources.

There are different isolation levels

1. Read Committed
2. Read Uncommitted
3. Snap-shot
4. Serializable
5. Repeatable Read

Read More..   [0 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·