DB2 Database Fundamentals Quiz

Casual Mode - Take your time!

1 / 20
✓
Correct
0
✗
Incorrect
0
★
Score
0%
Multiple Choice

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?

  1. The application must release the row-level Share lock it holds and acquire an Update lock on the row
  2. The application must release the row-level Share lock it holds and acquire an Update lock on the table
  3. The row-level Share lock will automatically be converted to a row-level Up-date lock
  4. The row-level Share lock will automatically be escalated to a table-level Up-date lock
Change Mode