Eccouncil Exam 312-49 Topic 1 Question 37 Discussion

Actual exam question for Eccouncil's 312-49 exam

Question #: 37
Topic #: 1

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?

AStart and end points for log sequence numbers are specified

BStart and end points for log files are not specified

CStart and end points for log files are specified

DStart and end points for log sequence numbers are not specified

Show Suggested Answer

Suggested Answer: B

by Harrison at Dec 24, 2022, 02:28 AM

Limited Time Offer

25%

Off

Get Premium 312-49 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Leslie

Whoa, this question is a real log-ic puzzle! But I think D is the way to go - NULL means no limits on the log sequence.

upvoted 0 times

...

Reed

24 hours ago

D is the right answer. Leaving the start and end points as NULL means the query will just give me the active part of the log, without any restrictions on the sequence numbers.

upvoted 0 times

...

Goldie

7 days ago

I'm pretty sure the answer is D. Passing NULL for the start and end points means that the query will return the active portion of the log file, without any specific boundaries.

upvoted 0 times

...

Kristel

9 days ago

But assigning NULL values means the start and end points for log sequence numbers are not specified.

upvoted 0 times

...

Kassandra

10 days ago

The correct answer is D. Assigning NULL values means that the start and end points for the log sequence numbers are not specified, so the query will return the active portion of the transaction log file.

upvoted 0 times

...

Alyssa

11 days ago

I disagree, I believe the answer is A.

upvoted 0 times

...

Kristel

13 days ago

I think the answer is D.

upvoted 0 times

...

Nan

14 days ago

I think the answer is D. The NULL values imply that the start and end points for the log sequence numbers are not specified, so the query will return the active portion of the log file.

upvoted 0 times

...