Which of the Following Is a Type of Cursor Concurrency

question 2

Multiple Choice

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

---

Definitions:

Decreased Acceptance

A reduction in the approval, agreement, or support for something or someone.

Team-Maintenance Role

A role within a group focused on maintaining positive relationships and team cohesion.

Verbal Support

The act of expressing encouragement, agreement, or backing through spoken words.

Nonverbal Support

The use of body language, facial expressions, gestures, and other nonverbal cues to reinforce or complement verbal communication.