Select from following answers:- READ_ONLY
- SCROLL_LOCK
- OPTIMISTIC

- PESSIMISTIC
- All Above
OPTIMISTIC cursor specifies that positioned updates or deletes made through the cursor do not succeed if the row has been updated since it was read into the cursor. SQL Server does not lock rows as they are read into the cursor. i.e. no lock is obtained until the user updates the data
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator