Ado.Net Interview Questions and Answers for Fresher - 1

Question: 1

Write about the ADO.NET Disconnected model?

• The ADO.NET disconnected model is based on using a Data Set object as an in memory cache.
• A Data Adapter serves as the intermediary between the data Set and the Data Source that loads the cache with data.
• After the completion of the work the Data Adapter returns the connection object to the pool, thus disconnecting the data from the data Source.

Question: 2

Define complex data binding?

It is only available on controls that include properties to specify a data source and data members on the data source.

The controls are

List Box,

Checked List Box,

Combo Box and

Data Grid View

Question: 3

What is called Virtual mode?

In order to handle excessive memory requirements, a Data Grid View can be run in virtual mode by setting its Virtual Mode property to true. In this mode the application takes responsibility for maintaining an underlying data cache to handle the population, editing and deletion of Data Grid View cells based on actions of the user.

Question: 4

What is the purpose of the Execute Scalar method?

This method executes the query and returns the value of the first column in the first row of the result set as a scalar value the following code illustrates the usage.