With which type of SQL Server recovery model are all database changes logged?
A. Differential recovery
B. Full recovery
C. Simple recovery
D. Bulk-logged recovery
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