Question

Point out the correct statement.

(a) The Database Engine supports two types of checkpoints

(b) Long-running uncommitted transactions decrease recovery time for all types of checkpoints

(c) Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database

(d) All of the mentioned

I have been asked this question at a job interview.

This intriguing question comes from Working With Transaction Log topic in section Performance Tuning and Optimization of SQL Server

Answer 1

The correct choice is (c) Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database

The best I can explain: Log truncation frees space in the log file for reuse by the transaction log.