Microsoft Technologies, ADO.Net Interview Questions - SlightBook

Total available count: 25
Subject - Microsoft Technologies
Subsubject - ADO.NET

1

Can you inherit from SqlConnection class?

2

Explain about ADO.NET namespaces which are required to connect database?

3

Explain about ADO.NET support namespaces?

4

Explain about asynchronous execution of commands?

5

Explain about Row States and Row Versions?

6

Explain about SqlCommand.CommandTimeout property?

7

Explain differences between Dataset and Datareader?

8

Explain the methods of DataAdapter.Update() and DataSetAcceptChanges()?

9

Explain the steps to access the database in ADO.NET?

10

How can a user determine which SQL commands are part of a transaction?

11

How to connect a database through SqlConnection?

12

How to convert a DataSet into a DataReader?

13

How to fill a DataSet?

14

Is it possible to update the database by using SqlDataReader?

15

Types of DataSet in ADO.NET?

16

What are the differences between ADO and ADO.NET?

17

What are the two fundamental objects in ADO.NET?

18

What is Diffgram in ADO.NET? When do we use Diffgram?

19

What is the difference between DataSet.Copy() and DataSet.Clone()?

20

What is the full-form of ADO?

21

What is the importance of ExecuteNonQuery, ExecuteReader and ExecuteScalar methods in SqlCommand?

22

What is the meaning of object pooling?

23

What is the purpose of database transactions?

24

What is the use of SqlParameter.Direction?

25

Why will an ASP.NET user account be created in the database for an ASP.NET web application?