You want to ensure the following:

*Statements in a particular transaction cannot read data that has been altered but not committed.
*Other transactions cannot modify data read by the current transaction until the transaction commits.
*Other transactions cannot insert rows with key values that would fall into the range read by statements in the current transaction until that transaction completes.

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

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response