Wednesday, 8 March 2017

37 Best ADO.NET Interview Questions and Answers [ADO.NET]

ADO.NET Interview Questions

ADO.Net is ActiveX Data Objects which is very important feature of .Net Framework. ADO.Net framework work with data with set of classes to handle data access by connecting with databases and and XML files.

  1. What is ADO.NET?
  2. What is the difference between ADO and ADO.NET?
  3. What are the different components in ADO.NET?
  4. What is the namespace that has the data functionality class in .Net?
  5. What is difference between dataset and datareader?
  6. What is use of System.Data.SqlClient and System.Data.OleDB ?
  7. What are the methods provided by the command object and what is the use of command objects? What is the use of data adapter?
  8. What is the Data Adapter Object in ADO.NET?
  9. What are Dataset objects?
  10. What are basic methods of Data adapter?
  11. What is DataTable in ADO.NET?
  12. What is the DataReader in ADO.Net?
  13. How can we close connection object after my data reader is closed?
  14. How can we use stored procedure in ADO.NET and how can provide parameters to the stored procedures?
  15. What is the SqlCommandBuilder?
  16. How do you fill the dataset?
  17. What is the Connection object in ADO.NET?
  18. What is ExecuteScalar method in ADO.NET?
  19. What are the various methods provided by the dataset object to generate XML?
  20. How can we save all data from dataset?
  21. How can we check which rows have changed since dataset was loaded?
  22. How can we add/remove row is in “Data Table” object of “Dataset”?
  23. What is basic use of “DataView”?
  24. How can create a SqlConnection?
  25. What is the difference between “Dataset” and “Data Reader”?
  26. How can we load multiple tables in a Dataset?
  27. How can we add relation between tables in a Dataset?
  28. What is the use of Command Builder?
  29. What’s difference between “Optimistic” and “Pessimistic” locking?
  30. How many ways are there to implement optimistic locking in ADO.NET?
  31. Explain in detail the fundamental of connection pooling?
  32. How to enable and disable connection pooling?
  33. How can we perform transactions in .NET?
  34. What is difference between Dataset.Clone() and Dataset.Copy()?
  35. Can you explain the difference between an ADO.NET Dataset and an ADO Record set?
  36. How can do pessimistic locking?
  37. What is Maximum Pool Size in ADO.NET Connection String?

1 comment:

Note: only a member of this blog may post a comment.