You are writing an application that accesses a single Microsoft SQL Server database. You must use transactions to ensure consistency between two of the database tables. You must choose the transaction type with the least impact on performance.

What should you do?

 Posted by Rajkatie on 9/27/2012 | Category: ADO.NET Interview questions | Views: 1156 | Points: 40
Select from following answers:
  1. Use distributed transactions.
  2. Use promotable transactions.
  3. Use transactions within SQL Server stored procedures.
  4. All Above

Show Correct Answer

Source: MeasureUp.Com | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response