Which command is used to prevent other users from making changes to a table?
A) COMMIT
B) COMMIT TABLE
C) BLOCK
D) LOCK TABLE

Question

Which command is used to prevent other users from making changes to a table?
A) ​COMMIT
B) ​COMMIT TABLE
C) ​BLOCK
D) ​LOCK TABLE

Quizplus · Accepted Answer

The LOCK TABLE command is used to prevent other users from making changes to a table. It enables us to exclusively lock a table to perform a transaction, making sure that no other users can modify the data until we have finished the transaction. The COMMIT command is used to save all uncommitted changes to the database, but it does not prevent other users from making changes to the table. The COMMIT TABLE and BLOCK commands are invalid SQL commands.

Which Command Is Used to Prevent Other Users from Making