Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
A. Lock level
B. Transaction isolation level
C. Cursor concurrency setting
D. Locking hints
Answer: Option A
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