You want to ensure the following:
1) Statements in the transaction should not be able to read data altered by other transactions if those transactions have not yet been committed.

2) Statements in other transactions should not be able to read data altered by the current transaction until the current transaction commits.

3)Other transactions should be able to insert new rows that meet the search conditions of statements in the current transaction.

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: 1749 | Points: 40
Select from following answers:
  1. SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
  2. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
  3. SET TRANSACTION ISOLATION LEVEL SNAPSHOT
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response