An unbuffered database query will: (Choose 2)
Suggested Answer: B
Get Premium 200-710 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
30 comments · newest first
EV
Evan
1 year ago
I thought unbuffered queries were slower overall.
HO
Holley
1 year ago
Totally agree with A and C!
BR
Brynn
1 year ago
Wait, does unbuffered really use less memory?
GA
Gail
1 year ago
I think A and D make more sense.
FL
Flo
1 year ago
A and C are correct!
JU
Justine
1 year ago
I’m a bit confused; I thought unbuffered queries were mainly about performance, but I’m not sure which options apply here.
TA
Tammara
1 year ago
I feel like unbuffered queries are supposed to use less memory, but I can't recall if they actually return all data faster.
RE
Reta
1 year ago
I think unbuffered queries might return the first data faster, but I'm not entirely sure about the memory usage part.
AN
Annelle
1 year ago
I remember practicing a question like this, and I think unbuffered queries do help free up connections faster for other scripts.
RO
Robt
1 year ago
This question seems a bit tricky, but I think I can work through it. Let me carefully read through the options and think about the flow of Instant Message and Presence delivery.
PA
Pansy
1 year ago
Okay, let's see here. Ambiguous requirements, poor design, and incorrect translation of design into code all seem like potential causes of defects. I wonder what the "signed off requirements" option could be referring to?
LE
Lemuel
2 years ago
A and D, eh? Looks like the exam gods want us to choose between 'fast and furious' or 'slow and steady'. Gotta love those database dilemmas!
CE
Ceola
1 year ago
I think I'll go with A and D too. Can't go wrong with faster and less memory usage.
SA
Santos
1 year ago
Yeah, it's always a trade-off between speed and efficiency with database queries.
ST
Stefania
1 year ago
D) Use less memory
CH
Cherri
1 year ago
A) Return the first data faster
TI
Timothy
2 years ago
A and D, huh? Sounds like a classic case of trading speed for memory. I wonder if they have a query that's both fast and efficient - the holy grail of database queries!
MA
Mariann
1 year ago
Exactly, finding a query that's both fast and efficient is the ultimate goal.
SH
Shantell
1 year ago
C) Free connection faster for others scripts to use
AN
Angelo
1 year ago
Yeah, it's always a trade-off between speed and efficiency in database queries.
AR
Arlean
1 year ago
D) Use less memory
CU
Curtis
2 years ago
A) Return the first data faster
VI
Virgilio
2 years ago
Wait, if it frees the connection faster, doesn't that mean it also returns all the data faster? I'm so confused now. Maybe I'll just guess and hope for the best.
BR
Britt
2 years ago
C) Free connection faster for others scripts to use
IL
Ilda
2 years ago
A) Return the first data faster
LU
Luann
2 years ago
But wouldn't option D also be correct? Using less memory is important for efficiency.
AL
Alysa
2 years ago
I always thought unbuffered queries were faster overall, not just for the first bit. But I guess B is out then. Hmm, I'll go with A and C.
BO
Bong
2 years ago
I agree with Simona, option A makes sense because it doesn't wait to fetch all data before returning.
FA
Fausto
2 years ago
A and D seem like the correct answers. An unbuffered query doesn't wait to load all the data before returning it, which means you get the first bit faster and use less memory. Perfect for when you just need the top result.
SI
Simona
2 years ago
I think an unbuffered database query will return the first data faster.