True Or False

Question 11 :

READ COMMITTED is the default isolation level.


A). True
B). False
Answer : Option A

Question 12 :

A differential backup makes a copy of the entire database.


A). True
B). False
Answer : Option B

Question 13 :

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


A). True
B). False
Answer : Option A

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


Question 14 :

SERIALIZABLE is the strictest isolation level.


A). True
B). False
Answer : Option A

Question 15 :

With SQL Server pessimistic locking, no lock is obtained until the user updates the data.


A). True
B). False
Answer : Option B