Exercise: Managing Databases With Sql Server 2000

Questions for: Managing Databases With Sql Server 2000

With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
A:
True
B:
False
C:
D:
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
SERIALIZABLE is the strictest isolation level.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
SQL Server supports three recovery modes: simple, full and Bulk.
A:
True
B:
False
C:
D:
Answer: A

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

📖
📝
💬
👁️
A differential backup makes a copy of the entire database.
A:
True
B:
False
C:
D:
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
READ COMMITTED is the default isolation level.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz