Multiple choice technology databases

Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?

  1. The cursor is moved to another row

  2. The row the cursor is on is deleted by the application

  3. The row the cursor is on is deleted by another application

  4. The row the cursor is on needs to be updated by another application

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Under DB2's Cursor Stability isolation level, locks are held only on the row where the cursor is currently positioned. When the application deletes that row, the cursor no longer has a row to position on, so the lock is released. Moving the cursor to another row also releases the previous lock.

Keep practicing — related questions