ADO.Net Interview Questions

By | April 28, 2014

  1. Does SQLClient and OLEdb class share the same functionality
  2. How can we load multiple tables in to Dataset?
  3. What is the difference between data reader & data set
  4. Why edit is not possible in repeater?
  5. Difference between SqlCommand and SqlCommandBuilder?
  6. How many records can take clustured index in SQL Server?
  7. Why can’t we use Multiple inheritance and garbage collector in parallel in .NET?
  8. What is ADO.NET?
  9. Can we connect two datareader to same data source using single connection at same time?
  10. What is the execution procedure in oracle ?
  11. How to find the given query is optimised one or not?
  12. How to copy the contents from one table to another table and how to delete the source table in ado.NET?
  13. What is the difference between data reader and data adapter.
  14. How to copy the contents from one table to another table and how to delete the source table in ado.NET?

================================================================================================== What is the namespace in which .NET has the data functionality classes ? Can you give a overview of ADO.NET architecture ? What are the two fundamental objects in ADO.NET ? What is difference between dataset and datareader ? What are major difference between classic ADO and ADO.NET ? What is the use of connection object ? What is the use of command objects and what are the methods provided by the command object ? What is the use of dataadapter ? What are basic methods of Dataadapter ? What is Dataset object? What are the various objects in Dataset ? How can we connect to Microsoft Access , Foxpro , Oracle etc ? How do we connect to SQL SERVER , which namespace do we use ? How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures? How can we force the connection object to close after my datareader is closed ? I want to force the datareader to return only schema of the datastore rather than data ? How can we fine tune the command object when we are expecting a single row or a single value ? Which is the best place to store connectionstring in .NET projects ? What are steps involved to fill a dataset ?(Twist :- How can we use dataadapter to fill a dataset ?) What are the various methods provided by the dataset object to generate XML? How can we save all data from dataset ? How can we check that some changes have been made to dataset since it was loaded ?(Twist :- How can cancel all changes done in dataset ? ,How do we get changed value dataset ? ) How add/remove row’s in “DataTable” object of “DataSet” ? What’s basic use of “DataView” ? What’s difference between “DataSet” and “DataReader” ? How can we load multiple tables in a DataSet ? How can we add relation’s between table in a DataSet ? What’s the use of CommandBuilder ? What’s difference between “Optimistic” and “Pessimistic” locking ? How many way’s are there to implement locking in ADO.NET ? How can we perform transactions in .NET? What’s difference between Dataset. clone and Dataset. copy ? ================================================================================================

Leave a Reply