Guru's Guide to SQL Server Architecture and Internals, The

Knowledge Measure

1. True or false: The Simple recovery model fully logs all operations except nonlogged operations such as BULK INSERT.

2. When COMMIT is executed from within a nested transaction, what percentage of the transaction's modifications is written to the transaction log?

3. When ROLLBACK is executed from within a nested transaction, what percentage of the transaction's modifications is rolled back?

4. True or false: SQL Server automatically rolls back a transaction that was initiated from an aborted Transact-SQL batch.

5. Is Transact-SQL's CREATE INDEX command a member of the list of nonlogged (or minimally logged) commands?

6. Describe the difference between a fully logged and minimally logged command.

7. What DBCC command reports the oldest active transaction ...