Question

Point out the wrong statement.

(a) For performance reasons, the Database Engine performs modifications to database pages in memory

(b) Log truncation does reduce the size of the physical log file

(c) Log truncation is essential to keep the log from filling

(d) None of the mentioned

I got this question in an online quiz.

I'm obligated to ask this question of Working With Transaction Log topic in chapter Performance Tuning and Optimization of SQL Server

Answer 1

The correct option is (b) Log truncation does reduce the size of the physical log file

Explanation: To reduce the physical size of a physical log file, you need to shrink the log file.