The ____ command will prevent two users from trying to make changes to the same table at the same time.
A) SHARED LOCK
B) EXCLUSIVE LOCK
C) LOCK TABLE
D) TABLE LOCK

Question

The ____ command will prevent two users from trying to make changes to the same table at the same time.​
A) ​SHARED LOCK
B) ​EXCLUSIVE LOCK
C) ​LOCK TABLE
D) ​TABLE LOCK

Quizplus · Accepted Answer

The LOCK TABLE command is used to prevent two users from trying to make changes to the same table at the same time. This command can be used to either acquire a shared lock or an exclusive lock on the table, depending on the requirement. The shared lock allows multiple users to access the table for reading purposes, while the exclusive lock restricts all other users from accessing the table until the lock is released. The other options listed are not valid commands in SQL.

The ____ Command Will Prevent Two Users from Trying to Make