ADO.Net Interview Question and Answers

36. What is the difference between int and int32?
  Both are same. System.Int32 is a .NET class. Int is an alias name for System.Int32.
 
Your Name Your Email-ID
Your Answer
37. What is the role of the DataReader class in ADO.NET connections?
  It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed.
 
Your Name Your Email-ID
Your Answer
38. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
  SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.
 
Your Name Your Email-ID
Your Answer
39. What are acid properties?
 
  • Atomicity
  • Consistency
  • Isolation
  • Durability
 
Your Name Your Email-ID
Your Answer
40. What is DataRowCollection?
  Similar to DataTableCollection, to represent each row in each Table we have DataRowCollection.
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 8 of 16