SQL Server supports three recovery modes: simple, full and Bulk.
Options
A. True
B. False
Correct Answer
True
Explanation
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
More questions
1. Which of the following is true concerning an ODBMS?
Options
A. They have the ability to store complex data types on the Web.
B. They are overtaking RDBMS for all applications.
C. They are most useful for traditional, two-dimensional database table applications.