Thecommand can be used to view the contents of a record when it is anticipated that the record will need to be modified. It j shared lock on the record$($s$)$ to be changed and prevents any other user from acquiring a lock on the same record $($s$).$O SELECT...LOCK TABLEO COMMIT...LOCK TABLEO SELECT...FOR UPDATEO COMMIT...FOR UPDATE