Exam 312-49v10 topic 1 question 541 discussion

The answer should be = D.Start and end points for log sequence numbers are not specified. According to the EC-council Database Forensic Module - In the Collecting Active Transaction Logs Using SQL Server Management Studio section, "Assigning NULL value imply that the start and end points for the log sequence numbers LSN are not specified"

SELECT * FROM ::fn_dblog(NULL, NULL) Explanation of each part - SELECT: A SQL keyword used to retrieve data from a database. *: wildcard character instructs SQL to return all available columns from the source. FROM: A SQL keyword indicating the data source. Everything that follows FROM specifies which table, view, or function is being queried. ::fn_dblog: fn_dblog is an undocumented, read-only table-valued SQL function. It allows viewing transaction log records. The prefix (::) is a required syntax element for calling certain built-in functions or internal functions in SQL. (NULL, NULL): fn_dblog typically accepts two parameters representing a starting Log Sequence Number (LSN) and an ending LSN to define which log records to retrieve. NULL, NULL means that no specific start or end LSN is defined. Thus, the function returns all active log records in the transaction log.

D < Assigning NULL values implies that the start and end points for log sequence numbers (LSNs) are not specified

According to EC Council, (NULL,NULL) means the start and end points are not specified.