Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Zend 200-710 Exam - Topic 6 Question 29 Discussion

Posted by Arminda on May 08, 2022 at 03:47 AM

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
↳ replying to Lemuel
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
↳ replying to Lemuel
Yeah, it's always a trade-off between speed and efficiency with database queries.
ST
Stefania 1 year ago
↳ replying to Lemuel
D) Use less memory
CH
Cherri 1 year ago
↳ replying to Lemuel
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
↳ replying to Timothy
Exactly, finding a query that's both fast and efficient is the ultimate goal.
SH
Shantell 1 year ago
↳ replying to Timothy
C) Free connection faster for others scripts to use
AN
Angelo 1 year ago
↳ replying to Timothy
Yeah, it's always a trade-off between speed and efficiency in database queries.
AR
Arlean 1 year ago
↳ replying to Timothy
D) Use less memory
CU
Curtis 2 years ago
↳ replying to Timothy
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
↳ replying to Virgilio
C) Free connection faster for others scripts to use
IL
Ilda 2 years ago
↳ replying to Virgilio
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.
0/2000 characters

Save Cancel