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

2 months ago

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

Kara

13 days ago

Exactly, NULL values in this context mean that there are no specific start and end points for the log sequence numbers.

upvoted 0 times

...

Kara

1 months ago

That makes sense, NULL values indicate that the start and end points for log sequence numbers are not specified.

upvoted 0 times

...

Kara

1 months ago

I agree, D is the correct option because NULL values mean no limits on the log sequence numbers.

upvoted 0 times

...

Reed

2 months 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

2 months 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

Jin

11 days ago

Exactly, that's why the answer is D.

upvoted 0 times

...

Sheldon

17 days ago

So, it displays the active portion of the log file.

upvoted 0 times

...

Marcelle

1 months ago

I agree, passing NULL means no specific boundaries.

upvoted 0 times

...

Doyle

1 months ago

I think the answer is D.

upvoted 0 times

...

Kristel

2 months ago

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

upvoted 0 times

...

Kassandra

2 months 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

Shelia

1 months ago

B) Start and end points for log files are not specified

upvoted 0 times

...

Haydee

1 months ago

A) Start and end points for log sequence numbers are specified

upvoted 0 times

...

Alyssa

2 months ago

I disagree, I believe the answer is A.

upvoted 0 times

...

Kristel

2 months ago

I think the answer is D.

upvoted 0 times

...

Nan

2 months 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

...