ADO.Net Interview Question and Answers

21. What is the difference between OLEDB Provider and SqlClient ?
  SQLClient .NET classes are highly optimized for the .net / sqlserver combination and achieve optimal results. The SqlClient data provider is fast. It's faster than the Oracle provider, and faster than accessing database via the OleDb layer.
 
Your Name Your Email-ID
Your Answer
22. What is the use of Parameter Object?
  In ADO Parameter object provides information about a single parameter used in a stored procedure or query.
 
Your Name Your Email-ID
Your Answer
23. What is DataAdapter?
  DataSet contains the data from the DataAdapter which is the bridge between the DataSet and Database. DataAdapter provides the way to retrieve and save data between the DataSet and Database. It accomplishes this by means of request to the SQL Commands made against the database.
 
Your Name Your Email-ID
Your Answer
24. What does ADO mean?
  ADO stands for ActiceX Data Objects.It was introduced few years ago as a solution to accessing data that can be found in various forms, not only over a LAN but over the internet. It replaced the data access technologies RDO(Remote Data Objects) and DAO (Data Access Objects).
 
Your Name Your Email-ID
Your Answer
25. Name some ADO.NET Objects?
 
  • Connection Object
  • DataReader Object
  • Command Object
  • DataSet Object
  • DataAdapter Object
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 5 of 16