With this type of SQL Server cursor concurrency no lock is...

Home / Database / SQL Server 2000 / Question

Examveda

With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

A. READ_ONLY

B. SCROLL_LOCK

C. OPTIMISTIC

D. PESSIMISTIC

Answer: Option C

This Question Belongs to Database >> SQL Server 2000

Related Questions on SQL Server 2000

A. Differential recovery

B. Full recovery

C. Simple recovery

D. Bulk-logged recovery

View Answer

A. #

B. %

C. &

D. @

View Answer

A. Windows-only security

B. Both SQL Server and Windows-only security

C. Mixed security

D. SQL Server only security

View Answer

A. REPEATABLE READ

B. SERIALIZABLE

C. READ COMMITTED

D. READ UNCOMMITTED

View Answer