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 Cursor Stability isolation level, a lock is held only while the cursor remains on the current row. When the application deletes that row, the lock must be released as the row no longer exists for the cursor to point to. Option A describes normal cursor movement, option C and D involve operations by other applications which would require different locking behaviors.

Keep practicing — related questions