With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
A. True
B. False
Answer: Option B
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
What mode of authentication does SQL Server NOT provide?
A. Windows-only security
B. Both SQL Server and Windows-only security
C. Mixed security
D. SQL Server only security
The strictest transaction isolation level provided by SQL Server is called:
A. REPEATABLE READ
B. SERIALIZABLE
C. READ COMMITTED
D. READ UNCOMMITTED
Join The Discussion