You want to ensure the following:

1) Data read by any statement in the transaction must be transactionally consistent with how that data existed at the start of the transaction.

2) Other transactions should be able to write data to rows selected by the transaction even when the transaction has yet to commit.

Which of the following Transact-SQL statements can you use to accomplish this task ?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 2576 | Points: 40
Select from following answers:
  1. SET TRANSACTION ISOLATION LEVEL SNAPSHOT
  2. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
  3. SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response