Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
ASP.NET
« Previous
Next »
Which of the following is faster and consume lesser memory?
Options
- SQLDataReader
- Data Set
CORRECT ANSWER : SQLDataReader
Discussion Board
answer
Answer is DATAREADER as it fetches only one row at a time.
Ankita 10-23-2022 03:34 AM
answer
Answer is DATAREADER as it fetches only one row at a time whereas Dataset stores it as a table as whole.so it need much more network resourses.
Neethu 07-17-2018 02:04 AM
Online Practice Test >ASP.NET « Previous Next » Which of the following is faster and consume lesser memory?
Sqldatareader is fast as compare to Dataset.Because it stored data in forward only and also stores only one record at a time.And dataset stores all records at the same time.This is the reason, SqlDataReader is faster than Dataset.
pranav 06-28-2017 12:27 PM
no satisfy with answer
Please give me the best answer that sqldatareader is faster than Dataset.
Deepak singh 06-16-2015 03:35 PM
Verify
SQLDataReader can not be fast because it always require open connection till reading is not completed from database but yes it uses less memory
Ashok kumar 03-11-2015 06:38 AM
answer.
kindly share the answer of the multiple choice of question.
anwer 08-21-2014 07:43 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
ASP.NET (41)
ASP.NET (16)
ASP.NET (16)
ASP.NET for Freshers (19)
ASP.NET for Experienced (19)
ASP.NET (20)
ASP.NET (20)
ASP.NET (25)
ASP.NET (20)
ASP.NET (20)
ASP.NET (20)
ASP.NET (20)
Dot.Net (100)
.NET Framework (26)
.NET Caching (7)
.NET Remoting and webservices (10)
.NET Security (11)
ADO.NET (10)
C#.NET (25)
VB.NET (33)
DOT.NET (10)
C#.NET freshers (20)
C#.NET freshers (20)
C#.NET experienced (20)
C#.NET (25)
C#.NET (20)
Sharepoint (20)
Sharepoint 2007 (15)
WCF (50)
WPF (45)
Advertisement
▲