ADO.NET Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ADO.NET Interview Questions

Questions Answers Views Company eMail

Advantage of ADO.Net?

QualSoft, TCS,

2 11959

How would u connect to database using .NET?

TCS, Tesco,

5 10840

What are relation objects in dataset and how & where to use them?

1 6052

Difference between OLEDB Provider and SqlClient ?

2 11406

What are the different namespaces used in the project to connect the database?

3 8145

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

TCS,

3 33090

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

4 12132

Explain different methods and Properties of DataReader which you have used in your project?

2 7831

What happens when we issue Dataset.ReadXml command?

1 6630

How to find the count of records in a dataset?

6 23095

How to check if a datareader is closed or opened?

1 19778

What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?

TCS,

1 20352

What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 13469

Differences between dataset.clone and dataset.copy?

Ksb, TCS,

2 8362

What is the use of parameter object?

CDC, Ksb,

4 10647

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is ado in agriculture?

965

What is namespace in ado.net?

1015

What is meant by executenonquery?

935

What are the steps you will take to improve performance? Will you use dataset or datareader?

991

What is the maximum pool size in ado.net connection string?

939

Explain the different row versions available in table?

1058

What is sql command in ado net?

956

Which database is the ado.net?

970

What are advantages of microsoft-provided data provider classes in ado.net?

999

Describe datareader object of ado.net with example.

935

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

1005

What does adodb stand for?

1051

What is ado and rdo?

901

Which keyword is used to accept variable number of parameters?

1118

What is the difference between Optimistic and Pessimistic locking?

977

For More Un-Answered { ADO.NET } Questions Click Here