The Default Cursor Concurrency Setting for a Static Cursor in SQL

question 22

Multiple Choice

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

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

---

Definitions:

Accountability

The obligation of an individual or organization to account for its activities, accept responsibility for them, and to disclose the results in a transparent manner.

Practical Intelligence

Intelligence that involves the ability to solve everyday problems by utilizing knowledge gained from experience in order to adapt to, shape, or select environments.

Sternberg's Triarchic Theory

A theory of intelligence that considers analytic, creative, and practical aspects.

Intrapersonal

Pertaining to the internal, psychological processes within an individual.