SQL Server 2000 - Technical MCQs

Q1:

With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

A READ_ONLY

B SCROLL_LOCK

C OPTIMISTIC

D PESSIMISTIC

ANS:C - OPTIMISTIC

No answer description is available. Let's discuss.