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.
Computer Proficiency Test Question Paper Pdf More
C++ Programming Coding Questions and Answers Pdf More
C Programming Viva Questions and Answers Pdf More
OOPS Objective Questions and Answers Pdf More
C Programming MCQ Questions and Answers Pdf More
100+ Physics Multiple Choice Questions Answers for Competitive Exams More
Spelling Test for Class/Grade 6, 7, 8, 9, 10 More
10th Anti-Colonial Movements the Birth of Nationalism Questions More
Understanding Secularism Class 8 Questions and Answers More
100+ Periodic Classification of Elements Questions and Answers More