SQL Server 2000 - Technical MCQs

Q1:

Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

A READ_ONLY

B SCROLL_LOCK

C OPTIMISTIC

D READCOMMITTED

ANS:D - READCOMMITTED

No answer description is available. Let's discuss.