Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?
A)SCROLL_LOCK
B)Optimistic
C)Serializable
D)Read only
E)Forward-only

Name: Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read? A)SCROLL_LOCK B)Optimistic C)Serializable D)Read only E)Forward-only
Brand: Quizplus
Rating: 4.8 (39 reviews)

Question

Quizplus · Accepted Answer

SCROLL_LOCK causes SQL Server to place an update lock on a row when the row is read.

Which of the Following Is a Type of Cursor Concurrency