The Default Cursor Concurrency Setting for a Keyset Cursor in SQL

question 68

Multiple Choice

The default cursor concurrency setting for a keyset cursor in SQL Server is ________.

• A)SCROLL_LOCK
• B)Optimistic
• C)Serializable
• D)Read only
• E)Pessimistic

---

Definitions:

Disjunctive Proposition

A logical statement that presents two or more alternatives, where the truth of any one alternative makes the proposition true.

Categorical Proposition

A proclamation that either affirms or contradicts something concerning all elements of a particular class.

Hypothetical Proposition

A compound proposition that uses the connective “if . . . then.”

Disjunctive Proposition

A statement in logic that presents two or more alternatives, where the truth of at least one alternative makes the proposition true.