312-49V11: Computer Hacking Forensic InvestigatorDemo

Question

While collecting Active Transaction Logs in SQL Server Management Studio, the query Select * from ::fn_dblog(NULL, NULL) displays the active part of the transaction log file. In this context, what does assigning NULL values imply?

A Start and end points for log sequence numbers are specified
B Start and end points for log files are not specified
C Start and end points for log files are specified
D Start and end points for log sequence numbers are not specified

Explanation

The two parameters of fn_dblog represent the starting and ending log sequence numbers. Setting both to NULL means no start or end LSN is specified, so the active log records are returned.

312-49V11: Computer Hacking Forensic InvestigatorDemo

AstroTutor

Notes

Readiness

QuestionQ9

Community Discussion