Computer Hacking Forensic Investigator (CHFI v10) — Question 56

While collecting Active Transaction Logs using SQL Server Management Studio, the query Select * from ::fn_dblog(NULL, NULL) displays the active portion of the transaction log file. Here, assigning NULL values implies?

Answer options

Correct answer: D

Explanation

Using NULL values in the query indicates that no specific start and end points for log sequence numbers have been defined, thus allowing the query to return all active transaction logs. Options A, B, and C incorrectly suggest that specific points are defined, which contradicts the purpose of using NULL in this context.