ADO.Net Interview Question and Answers

16. What are the major components of data provider?
 
  • The Connection object which provides a connection to the database.
  • The Command object which is used to execute a command.
  • The DataReader object which provides a forward–only, read only, connected recordset.
  • The DataAdapter object which populates a disconnected DataSet with data and performs update.
 
Your Name Your Email-ID
Your Answer
17. What do you mean by Dataset?
  A Dataset is a container where all the rows fetched from a database table.
It is the job of DataAdapter to fill the Dataset with rows from the database.
 
Your Name Your Email-ID
Your Answer
18. What keyword is used to accept a variable number of parameter in a method?
  Params.
 
Your Name Your Email-ID
Your Answer
19. What are the types of .Net data providers?
 
  • The OLE DB.NET data provider
  • The SQL Server.NET data provider
 
Your Name Your Email-ID
Your Answer
20. What are the advantage of ADO.Net?
 
  • Database Interactions Are Performed Using Data Commands
  • Data Can Be Cached in Datasets
  • Datasets Are Independent of Data Sources
  • Data Is Persisted as XML.
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 4 of 16