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