ADO.NET Interview Questions and Answers
Here you can find ADO.NET Interview Questions and Answers.
Why ADO.NET Interview Questions and Answers Required?
In this ADO.NET Interview Questions and Answers section you can learn and practice ADO.NET Interview Questions and Answers to improve your skills in order to face
technical inerview by IT companies. By Practicing these interview questions, you can easily crack any ADO.NET interview.
Where can I get ADO.NET Interview Questions and Answers?
AllIndiaExams provides you lots ADO.NET Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students,
freshers can download ADO.NET Interview Questions and Answers as PDF files and eBooks.
How to solve these ADO.NET Interview Questions and Answers?
You no need to worry, we have given lots of ADO.NET Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the
ADO.NET technical interview.
ADO .NET Interview Questions and Answers
What is Ado.NET?
ADO.NET is an object-oriented set of libraries that allows you to interact with data sources.
ADO.NET is a set of classes that expose data access services to the .NET programmer.
ADO.NET is also a part of the .NET Framework.
ADO.NET is used to handle data access.
ADO.NET is entirely based on XML.
ADO .NET Interview Questions and Answers
What are the two fundamental objects in ADO.NET?
There are two fundamental objects in ADO.NET.
Datareader - connected architecture and
Dataset - disconnected architecture.
ADO .NET Interview Questions and Answers
What are major difference between classic ADO and ADO.NET?
In ADO the in-memory representation of data is the recordset.A Recordset object is used to hold a set of records from a database table.
In ADO.NET we have dataset.A DataSet is an in memory representation of data loaded from any data source.
ADO .NET Interview Questions and Answers
What are the data access namespaces in .NET?
The most common data access namespaces :
System.Data
System.Data.OleDb
System.Data.SQLClient
System.Data.SQLTypes
System.Data.XML
System.Data.LINQ
ADO .NET Interview Questions and Answers
What is the use of connection object in ado.net?
The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database.
ADO .NET Interview Questions and Answers
What are the benefits of ADO.NET?
Scalability
Data Source Independence
Interoperability
Strongly Typed Fields
Performance
ADO .NET Interview Questions and Answers
What are the parts of ADO.NET?
ADO.NET is divided into the Dataset object for manipulating disconnected data and the .NET Data Providers for communicating with backend data stores and the
Dataset.
ADO .NET Interview Questions and Answers
Whate are different types of Commands available with DataAdapter ?
The SqlDataAdapter has
SelectCommand
InsertCommand
DeleteCommand
UpdateCommand
ADO .NET Interview Questions and Answers
What is the difference between an ADO.NET Dataset and an ADO Recordset?
Dataset can fetch source data from many tables at a time, for Recordset you can achieve the same only using the SQL joins.
A DataSet can represent an entire relational database in memory, complete with tables, relations, and views, A Recordset can not.
A DataSet is designed to work without any continues connection to the original data source; Recordset maintains continues connection with the original data source.
DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.
ADO .NET Interview Questions and Answers
What are the parameters that control most of connection pooling behaviors?
Connect Timeout
Max Pool Size
Min Pool Size
Pooling