Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?
A) SELECT...LOCK
B) SELECT...COMMIT
C) SELECT...FOR UPDATE
D) SELECT...FOR CHANGE

Question

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?​
A) ​SELECT...LOCK
B) ​SELECT...COMMIT
C) ​SELECT...FOR UPDATE
D) ​SELECT...FOR CHANGE

Quizplus · Accepted Answer

The keyword SELECT...FOR UPDATE creates a shared lock on a table to prevent another user from making changes to data in specified columns until the transaction using the lock is either committed or rolled back. Option A is incorrect because SELECT...LOCK does not exist in SQL syntax. Option B is incorrect because SELECT...COMMIT does not create a lock on the table. Option D is incorrect because SELECT...FOR CHANGE does not exist in SQL syntax.

Which Keywords Create a Shared Lock on a Table to Prevent