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 the Cursor Stability (CS) isolation level, DB2 acquires a lock on the row currently positioned by the cursor. When the application deletes the row, the lock is held until a commit or rollback occurs to ensure transaction integrity.

Keep practicing — related questions