?
Categories
Account

What is the purpose of the 'WITH (NOLOCK)' hint in SQL Server 2000?

  • 📥 Instant PDF Download
  • ♾ Lifetime Access
  • 🛡 Secure & Original Content

What’s inside this PDF?

Question: What is the purpose of the \'WITH (NOLOCK)\' hint in SQL Server 2000?

Options:

  1. To lock the table
  2. To prevent deadlocks
  3. To allow dirty reads
  4. To optimize performance

Correct Answer: To allow dirty reads

Solution:

\'WITH (NOLOCK)\' allows dirty reads by not placing shared locks on the data.

What is the purpose of the 'WITH (NOLOCK)' hint in SQL Server 2000?

Practice Questions

Q1
What is the purpose of the 'WITH (NOLOCK)' hint in SQL Server 2000?
  1. To lock the table
  2. To prevent deadlocks
  3. To allow dirty reads
  4. To optimize performance

Questions & Step-by-Step Solutions

What is the purpose of the 'WITH (NOLOCK)' hint in SQL Server 2000?
No concepts available.
Soulshift Feedback ×

On a scale of 0–10, how likely are you to recommend The Soulshift Academy?

Not likely Very likely
Home Practice Performance eBooks