Multiple choice technology databases

Which of the following are different locks in SQL SERVER?

  1. Intent

  2. Shared

  3. Exclusive

  4. Delete
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

SQL Server uses Intent locks (IS, IX), Shared locks (S), and Exclusive locks (X) as fundamental locking mechanisms. These prevent concurrent access conflicts. 'Delete' is an operation that acquires locks, not a lock type itself.

Keep practicing — related questions