IndiaBIX

Database - SQL Server 2000

Exercise : SQL Server 2000 - True or False
11.
READ COMMITTED is the default isolation level.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.
12.
A differential backup makes a copy of the entire database.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.
13.
SQL Server supports three recovery modes: simple, full and Bulk.
True
False
Answer: Option
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

14.
SERIALIZABLE is the strictest isolation level.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.
15.
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers