Which type of SQL Server cursor concurrency places an update lock...

Home / Database / SQL Server 2000 / Question

Examveda

Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

A. READ_ONLY

B. SCROLL_LOCK

C. OPTIMISTIC

D. READCOMMITTED

Answer: Option D

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