MENU
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?
Suggested Answer: B
Get Premium 312-49 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
34 comments · newest first
DE
Denna
11 months ago
I think it's D, not specified for log sequence numbers.
CH
Chanel
11 months ago
Definitely B, no points specified!
GL
Glen
12 months ago
Wait, are we sure about that? I thought NULL meant something else.
KR
Kris
12 months ago
Totally agree, it's all about the log sequence numbers!
AL
Alaine
1 year ago
NULL means no specific start/end points for log sequence numbers.
HE
Heike
1 year ago
If I remember correctly, using NULL should mean that we’re not specifying any particular log sequence numbers, which would support option D.
TA
Tayna
1 year ago
I feel like I might have seen something about this in our last class, but I can't recall if it was about log files or log sequence numbers.
MA
Malissa
1 year ago
I remember practicing a similar question where NULL values indicated that no specific range was set, so I’m leaning towards option D.
DE
Delsie
1 year ago
I think assigning NULL means that the start and end points for log sequence numbers are not specified, but I'm not entirely sure.
HO
Horace
1 year ago
This question seems straightforward. I'm pretty confident I know the right answer.
RE
Rex
1 year ago
The key is making sure the prices are tied to the customer's location. I think adding the regional price list to the agreement is the most straightforward solution.
VI
Viola
1 year ago
This seems straightforward. I'll carefully review the options and select the three mandatory activities that need to be performed after the DV920 upgrade.
JO
Joni
1 year ago
Hmm, I'm a bit confused by the wording here. I'll need to make sure I understand the difference between the server pool, qualification policy, and server pool policy before I can confidently select the right actions.
LE
Leslie
1 year 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.
KA
Kara
1 year ago
Exactly, NULL values in this context mean that there are no specific start and end points for the log sequence numbers.
KA
Kara
1 year ago
That makes sense, NULL values indicate that the start and end points for log sequence numbers are not specified.
KA
Kara
1 year ago
I agree, D is the correct option because NULL values mean no limits on the log sequence numbers.
RE
Reed
1 year 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.
GO
Goldie
1 year 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.
YU
Yun
1 year ago
Thanks for clarifying!
VA
Vallie
1 year ago
Yes, that's correct.
TA
Talia
1 year ago
So, the answer is D then.
FR
Frederica
1 year ago
I think you're right, NULL values mean no specific boundaries.
JI
Jin
1 year ago
Exactly, that's why the answer is D.
SH
Sheldon
1 year ago
So, it displays the active portion of the log file.
MA
Marcelle
1 year ago
I agree, passing NULL means no specific boundaries.
DO
Doyle
1 year ago
I think the answer is D.
KR
Kristel
1 year ago
But assigning NULL values means the start and end points for log sequence numbers are not specified.
KA
Kassandra
2 years 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.
SH
Shelia
1 year ago
B) Start and end points for log files are not specified
HA
Haydee
1 year ago
A) Start and end points for log sequence numbers are specified
AL
Alyssa
2 years ago
I disagree, I believe the answer is A.
KR
Kristel
2 years ago
I think the answer is D.
NA
Nan
2 years 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.