Multiple choice sql

What type of lock will deny users any access to a table?

  1. EXPLICIT

  2. IMPLICIT

  3. EXCLUSIVE

  4. SHARED

  5. READ ONLY

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

An EXCLUSIVE lock is used for data-modification operations. It prevents any other transaction from acquiring any type of lock on the resource (table or page) until the exclusive lock is released, effectively denying all other access.