ADO.NET INTERVIEW QUESTIONS AND ANSWERS

ADO.NET MOST ASKED Job Interview Questions. Read ADO.NET Interview Questions and Answers for Experienced, Freshers PDF Download.

Read ADO.NET Questions and Answers for Interview

How to find the count of records in a dataset?View Answer
what is data Adapter?View Answer
What is Isolation?View Answer
What is Atomicity?View Answer
Explain acid properties?View Answer
What is the provider and namespaces being used to access oracle database?View Answer
What provider ADO.net use by default?View Answer
What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not?View Answer
What are the two fundamental objects in ADO.NET?View Answer
What are the different row versions available in table?View Answer
What is data access layer?View Answer
If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?View Answer
what is bubbled event can u pls explain?View Answer
What is different between SqlCommand object and Command Behavior Object?View Answer
Can dataReader hold data from multiple tables?View Answer
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.View Answer
what is typed and untyped dataset?View Answer
How to call the SQL commands asynchronously in ADO.NET version 2.0?View Answer
How to copy the contents from one table to another table and how to delete the source table in ado.net?View Answer
How to find the given query is optimised one or not?View Answer
Why ca not we use Multiple inheritance and garbage collector paralelly in .net?View Answer
Difference between SqlCommand and SqlCommandBuilder?View Answer
why edit is not possible in repeater?View Answer
Does SQLClient and OLEdb class share the same functionality?View Answer
What is the difference between data reader and data set?View Answer
What is the difference between data reader and data adapter?View Answer
what are the advantages and disadvantages of using datalist?View Answer
What is Partial class?View Answer
How do you connect to SQL Server Database without using sqlclient?View Answer
What are the steps to connect to a database?View Answer
How do you update a Dataset in ADO.Net and How do you update database through Dataset?View Answer
What is Delegate?View Answer
What is connection String?View Answer
How can we load multiple tables in to Dataset?View Answer
Which one of the following objects is a high-level abstraction of the Connection and Command objects in ADO.NET?View Answer
What is the ExecuteScalar method?View Answer
Explain ExecuteNonQuery?View Answer
How can i retrieve two tables of data at a time by using data reader?View Answer
If we are not returning any records from the database, which method is to be used?View Answer
Can we do database operations without using any of the ADO.net objects?View Answer
can we connect two dataadapters to same data source using single connection at same time?View Answer
What is ADO.NET?View Answer