ADO.NET INTERVIEW QUESTION & ANSWERS
| 61. |
What are the two major parts of ADO.NET? |
| |
The DataSet object and the managed providers are the two parts of ADO.NET. |
| 62. |
Which method do you invoke on the DataAdapter control to load your generated dataset with data? |
| |
Fill () |
| 63. |
Define Clustered Index? |
| |
The data rows are stored in order based on the clustered index key. Data stored is in a sequence of the index. In a clustered index, the physical order of the rows in the table is the same as the logical (indexed) order of the key values. A table can contain only one clustered index. A clustered index usually provides faster access to data than does a non-clustered index. |
| 64. |
Define Non-Clustered Index? |
| |
The data rows are not stored in any particular order, and there is no particular order to the sequence of the data pages. In a clustered index, the physical order of the rows in the table is not same as the logical (indexed) order of the key values. |
| 65. |
What is disconnected data? |
| |
A data representation, such a DataSet, that doesn't require a continuous database connection.
|
