Explanation:A long-running transaction might exist at the start of the log backup. In this case, freeing the space might require another log backup. 5. 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
Answer:A
Explanation:A long-running transaction might exist at the start of the log backup. In this case, freeing the space might require another log backup. 5. 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
Explanation:To reduce the physical size of a physical log file, you need to shrink the log file. 6. ________ logging is not supported for memory-optimized tables.