FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

ADO.NET INTERVIEW QUESTION & ANSWERS

DOT Net
TAGS
71. What is difference between Optimistic and Pessimistic locking?
 
  • Optimistic locking multiple users can open the same record for updating, thus increase maximum concurrency.
  • Record is only locked when updating the record.
  • Pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user's can only view the data when there is pessimistic locking
Your Name Your Email-ID
Your Answer
 
72. Does an OleDbCommand object need to be closed?
  No, only the OleDbDataReader and OleDbConnection object need to be closed explicitly.
Your Name Your Email-ID
Your Answer
 
73. What is method to get XML and schema from Dataset?
  getXML () and get Schema ()
Your Name Your Email-ID
Your Answer
 
74. What method is used to populate a dataset using an XML file?
  Use the ReadXml method from the DataSet class.
Your Name Your Email-ID
Your Answer
 
75. What is basic use of DataView?
  DataViewrepresents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in datatable.
    Dataview has the following methods
  • Find
  • FindRow
  • AddNew
  • Delete
Your Name Your Email-ID
Your Answer