Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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?
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 1500 |
Select from following answers:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
using SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement you can ensure that T-SQL statements cannot read data that has been altered but not committed, that other transactions cannot modify data read by the current transaction until the transaction commits.
Show Correct Answer
measureup.com | |
< Previous :
You want to ensure that statements in the transact ...
Next > :
You want to ensure the following: 1) Data read ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You want to ensure the following: 1) Data read by any statement in ...
You want to ensure the following: 1) Statements in the transaction sh ...
You are configuring an appropriate transaction isolation level for a s ...
You are working on some errors raised by a some set of transactions. Y ...
Which of the following statements you can use to ensure that the SQL S ...
Which of the following statements will list the number of BEGIN TRANSA ...
You want to revert changes made during a transaction to the start of t ...
Which of the following statements can you use to specify the end of a ...
Latest Interview Questions
In.Net which is the parent class to create all windows service?
What is infonomics?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?
How can you detect the servername ?
How can you detect the host name and Ip address?
How can you detect the version properties?