True or false: The Simple recovery model fully logs all operations except nonlogged operations such as BULK INSERT.
When COMMIT is executed from within a nested transaction, what percentage of the transaction's modifications is written to the transaction log?
When ROLLBACK is executed from within a nested transaction, what percentage of the transaction's modifications is rolled back?
True or false: SQL Server automatically rolls back a transaction that was initiated from an aborted Transact-SQL batch.
Is Transact-SQL's CREATE INDEX command a member of the list of nonlogged (or minimally logged) commands?
Describe the difference between a fully logged and minimally logged command.
What DBCC command reports the oldest active transaction ...