The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified.It places a shared lock on the record(s)to be changed and prevents any other user from acquiring a lock on the same record(s).
A) SELECT...LOCK TABLE
B) COMMIT...LOCK TABLE
C) SELECT...FOR UPDATE
D) COMMIT...FOR UPDATE

Question

The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified.It places a shared lock on the record(s)to be changed and prevents any other user from acquiring a lock on the same record(s).​
A) ​SELECT...LOCK TABLE
B) ​COMMIT...LOCK TABLE
C) ​SELECT...FOR UPDATE
D) ​COMMIT...FOR UPDATE

Quizplus · Accepted Answer

The SELECT...FOR UPDATE command is used to view the contents of a record and place a shared lock on the record(s) to be modified, preventing other users from acquiring a lock on the same record(s). This is useful when it is anticipated that the record will need to be modified. Neither the SELECT...LOCK TABLE nor the COMMIT...LOCK TABLE commands exist in SQL, and the COMMIT command is used to permanently save changes to the database, not to acquire locks.

The ____ Command Can Be Used to View the Contents