ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
which one is faster execute reader, scalar, execute non 
query ?
 Question Submitted By :: Manoj Dagar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 1
execute reader
 
Is This Answer Correct ?    14 Yes 4 No
Ashish
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 2
Execute Non query
 
Is This Answer Correct ?    5 Yes 10 No
Ranjitha
 
 
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 3
Scalar Bcoz it return's only 1 result that's why scalar.
 
Is This Answer Correct ?    17 Yes 2 No
Amit
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 4
Reader... Bcoz It read the data directly from the database
 
Is This Answer Correct ?    5 Yes 2 No
Kalirajan
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 5
Execute Scalar
 
Is This Answer Correct ?    4 Yes 1 No
Akhilesh
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 6
Execute scalar  is faster so it is execute one row at the 
time
 
Is This Answer Correct ?    4 Yes 0 No
Abhishek
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 7
execute non query
 
Is This Answer Correct ?    0 Yes 1 No
Ftryttuyhg
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 8
most of the above answers are wrong

write answer is execute reader
 
Is This Answer Correct ?    1 Yes 1 No
Kamlesh Sharma
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 9
execute reader is fast
 
Is This Answer Correct ?    3 Yes 0 No
Santhosh
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 10
Execute Reader is faster it
 internally  stores result of a query as an array.
 
Is This Answer Correct ?    2 Yes 0 No
Monalika
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 11
Excute reader is to easy and quickly fetch the data from 
database. but in some casse excute non query is more useful 
than excute query , excute reader and excute scalar


thanks
 
Is This Answer Correct ?    3 Yes 0 No
Ananth
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 12
Execue reader
 
Is This Answer Correct ?    1 Yes 0 No
Kriss
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 13
Wrong Question , As ExceuteReader(),ExecuteNonQuery() and
ExecuteScaler() interact to database in same manner and we
all Know about the ExceuteReader(),ExecuteNonQuery() and
ExecuteScaler() serves for different purpose , as
ExceuteReader() reads data against select query , 
ExecuteScaler() reads single cell value and
ExecuteNonQuery() used for action query not returns any
result set.
 
Is This Answer Correct ?    9 Yes 1 No
D K
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 14
ExecuteNonQuery is used to inserts, updates, deletes.
ExecuteScaler is used to return values at a stretch; and 
can do data modifications too.
ExecuteReader is forward only reading of row by row.

The number of readers that can be open at a time has 
limitation (255)

Execute Scaler has no such restriction.  You can use 
sqlparameters (output) to get more than one field value,
you can use multiple queries to get more than one result.

Because of less overheads, ExecuteReader has a slight 
performance advantage but has limitations.

Do not forget to close Readers!
 
Is This Answer Correct ?    1 Yes 1 No
Satish V Itagi
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 15
execute reader
 
Is This Answer Correct ?    0 Yes 0 No
Xc V
 
  Re: which one is faster execute reader, scalar, execute non query ?
Answer
# 16
Scalar will be faster that the execute reader and execute 
non query. As scalar only fetch one column single row. 
Whereas execute reader may return numbers of record and 
though non-query will not return any records it will take 
time to identify the data types to validate be4 inserting 
the data
 
Is This Answer Correct ?    0 Yes 0 No
Anirudh G
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
How does VB.NET/C# achieve polymorphism?  3
What combination of methods are used to improve the speed of the fill() method of the DataAdapter? a) BeginFillData() and EndFillData() b) StartFillData() and EndFillData() c) BeginLoadData() and EndLoadData() d) StartLoadData() and EndLoadData() Syntax-Softtech2
What namespaces are imported by default in ASMX files?  2
When would you not use the oleDbConnection object? a) To connect to an SQL 7.0 database. b) To connect to a DB/2 database. c) To connect to an Access database. d) To connect to an SQL 6.5 database. Syntax-Softtech5
What?s the difference between Response.Write() andResponse.Output.Write()?  2
Difference between ASP Session and ASP.NET Session?  1
When an ASP.NET server control is added to a web form, Visual Studio .NET adds one item to the class for the form. What item is added? a) The event registration. b) A protected class member for the control. c) A default event handler for the click event. d) A default class that inherits from the control?s base class. Syntax-Softtech3
Is it possible to use two versions of assembly at the same time?If possible explain with code? Tech-Mahindra3
with which controls you worked in Asp.net 2.0? HP2
Why Web Services?  1
What is cookie less session? How it works?  1
What is FullTrust? Do GACed assemblies have FullTrust?  2
what is the difference between console.writeline &console.output.writeline?  2
How do you specify whether your data should be passed as Query string and Forms (Mainly about POST and GET)  2
What are clr?cts?cls? Microsoft1
Difference between .NET and previous version? Microsoft1
Where does the Web page belong in the .NET Framework class hierarchy? Visual-Soft1
What base class do all Web Forms inherit from?  4
How .net CLR works with n-tier application HCL2
Explain the life cycle of an ASP .NET page HCL2
 
For more ASP.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com