Which of the following is faster and consume lesser memory ?
Correct answer: A. SQLDataReader
- A. SQLDataReader
- B. Data Set
- C. Both A and B
- D. None of these
Explanation
SQLDataReader reads rows sequentially and keeps only a small amount of data in memory, whereas a DataSet stores a disconnected, in-memory copy of the results. Therefore, the reader is generally faster and more memory-efficient.
Report an error
The more specific you are, the faster it gets fixed. A source beats an opinion.
Prefer email? [email protected]
Practise Web and Mobile Development
268 free Web and Mobile Development MCQs from Software Engineering, each with the correct answer and an explanation. Unlimited attempts, no account needed.
Discussion
Stuck on an option, or know a faster way to get there? Ask or explain it here.
No comments yet. Be the first to explain this one.
Exams that ask Software Engineering questions like this
Software Engineering is on this paper prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for it.
More Web and Mobile Development questions
In ASP.NET in form page the object which contains the user name is ________________?
Which of the following is used to send email message from my ASP.NET page?
How do you register a user control ?
Which of the following ASP.NET object encapsulates the state of the client ?
Difference between Response.Write() and Response.Output.Write() ?
Which of the following is the way to monitor the web application ?