You are configuring an appropriate transaction isolation level for a session. You want to ensure that statements in the transaction cannot read data altered by other transactions if those transactions have not yet committed. Data selected during the transaction should be able to be modified during the current transaction by update statements issued later in the transaction. Other transactions should be able to insert data into rows with key values that would fall into the range read by statements in the current transaction.

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

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

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response