Slightbook.com Slightbook.com

ADO.NET Interview questions


Total available count: 25
Subject - Microsoft Technologies
Subsubject - ADO.NET
1
How can a user determine which SQL commands are part of a transaction?
2
Is it possible to update the database by using SqlDataReader?
3
What is the full-form of ADO?
4
What is the use of SqlParameter.Direction?
5
Explain differences between Dataset and Datareader?
6
What is the purpose of database transactions?
7
What is the importance of ExecuteNonQuery, ExecuteReader and ExecuteScalar methods in SqlCommand?
8
What is Diffgram in ADO.NET? When do we use Diffgram?
9
What are the two fundamental objects in ADO.NET?
10
Explain about SqlCommand.CommandTimeout property?
11
Explain about asynchronous execution of commands?
12
Can you inherit from SqlConnection class?
13
Why will an ASP.NET user account be created in the database for an ASP.NET web application?
14
Explain the steps to access the database in ADO.NET?
15
Explain about Row States and Row Versions?
16
Types of DataSet in ADO.NET?
17
What is the difference between DataSet.Copy() and DataSet.Clone()?
18
What is the meaning of object pooling?
19
Explain the methods of DataAdapter.Update() and DataSetAcceptChanges()?
20
How to connect a database through SqlConnection?
21
How to fill a DataSet?
22
Explain about ADO.NET namespaces which are required to connect database?
23
How to convert a DataSet into a DataReader?
24
What are the differences between ADO and ADO.NET?
25
Explain about ADO.NET support namespaces?