Question: What is the default isolation level in SQL Server 2000?

Options:

1. Read Uncommitted
2. Read Committed
3. Repeatable Read
4. Serializable

Correct Answer: Read Committed

Solution:

The default isolation level in SQL Server 2000 is Read Committed, which prevents dirty reads.