ADO.Net Interview Question and Answers

51. What is a 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
 
Your Name Your Email-ID
Your Answer
52. What is a 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.
 
Your Name Your Email-ID
Your Answer
53. What type of data model does an OleDbCommand object fill?
  An ADODataReader object.
 
Your Name Your Email-ID
Your Answer
54. Which method do you invoke on the DataAdapter control to load your generated dataset with data?
  DataAdapter’ fill () method is used to fill load the data in dataset.
 
Your Name Your Email-ID
Your Answer
55. What is difference between Dataset. clone and Dataset.copy?
  Clone: - It only copies structure, does not copy data.
Copy: - Copies both structure and data.
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 11 of 16