An application has acquired a Share lock on a row in a table and now wishes to update the row.
Which of the following statements is true?
A.
The application must release the row-level Share lock it holds and acquire an Update lock on
the row
B.
The application must release the row-level Share lock it holds and acquire an Update lock on
the table
C.
The row-level Share lock will automatically be converted to a row-level Update lock
D.
The row-level Share lock will automatically be escalated to a table-level Update lock
C
0
0
S lock (share)
The lock owner and any concurrent processes can read, but not change, the locked page or row. Concurrent processes can acquire S or U locks on the page or row or might read data without acquiring a page or row lock
0
0
automatically obtains row-level and table-level locks on behalf of DML operations
0
0