SQL Server 2000

Q1: SQL Server supports three recovery modes: simple, full and Bulk.

A True

B False

ANS:A - True

SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are: 1. Simple Recovery Model
2. Full Recovery Model
3. Bulk-logged Recovery Model



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.