Microsoft .Net Technologies :: ADO.NET Job Interview Questions and Answers

ADO.NET Interview Questions and Answers will guide us now that ADO.NET is a set of computer software components that can be used by programmers to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also be used to access data in non-relational sources. Learn ADO.NET with ADO.NET Interview Questions and Answers

1 ► What is ADO.NET?
2 ► can we connect two dataadapters to same data source using single connection at same time?
3 ► Can we do database operations without using any of the ADO.net objects?
4 ► If we are not returning any records from the database, which method is to be used?
5 ► how can i retrieve two tables of data at a time by using data reader?Data reader read and forward only, how is it possible to get 2 tables of data at a time?
6 ► Explain ExecuteNonQuery?
7 ► What is the ExecuteScalar method?
8 ► Which one of the following objects is a high-level abstraction of the Connection and Command objects in ADO.NET?
9 ► How can we load multiple tables in to Dataset?
10 ► What is connection String?
11 ► What is Delegate?
12 ► How do you update a Dataset in ADO.Net and How do you update database through Dataset?
13 ► What are the steps to connect to a database?
14 ► How do you connect to SQL Server Database without using sqlclient?
15 ► What is Partial class?
16 ► what are the advantages and disadvantages of using datalist?
17 ► What is the difference between data reader and data adapter?
18 ► What is the difference between data reader and data set?
19 ► Does SQLClient and OLEdb class share the same functionality?
20 ► why edit is not possible in repeater?
21 ► Difference between SqlCommand and SqlCommandBuilder?
22 ► Why ca not we use Multiple inheritance and garbage collector paralelly in .net?
23 ► How to find the given query is optimised one or not?
24 ► How to copy the contents from one table to another table and how to delete the source table in ado.net?
25 ► How to call the SQL commands asynchronously in ADO.NET version 2.0?
26 ► what is typed and untyped dataset?
27 ► 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 thedata(Which event and steps) and throw the exception.
28 ► Can dataReader hold data from multiple tables?
29 ► What is different between SqlCommand object and Command Behavior Object?
30 ► what is bubbled event can u pls explain?
31 ► 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?
32 ► What is data access layer?
33 ► What are the different row versions available in table?
34 ► What are the two fundamental objects in ADO.NET?
35 ► 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?
36 ► What provider ADO.net use by default?
37 ► What is the provider and namespaces being used to access oracle database?
38 ► Explain acid properties?
39 ► What is Atomicity?
40 ► What is Isolation?
41 ► what is data Adapter?
42 ► How to find the count of records in a dataset?