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:

Anthony Johnson

An African American who became one of the first African property owners and one of the first to have his right to own a slave legally recognized in the British American colonies.

Olaudah Equiano

An African writer and abolitionist who gained freedom from slavery and wrote an autobiography detailing his experiences, significantly influencing the abolitionist movement in Britain.

Jamestown

The first permanent English settlement in North America, founded in 1607 in present-day Virginia.