Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
The transaction isolation level controls the locking and row versioning behavior of Transact-SQL statements issued by a connection to SQL Server. Which of the following transaction isolation levels is the default in SQL Server 2012?
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 569 |
Select from following answers:
READ COMMITTED specifies that statements cannot read data that has been modified but not committed by other transactions. This prevents dirty reads. Data can be changed by other transactions between individual statements within the current transaction, resulting in nonrepeatable reads or phantom data. This option is the SQL Server default.
Show Correct Answer
Many Interviews |
< Previous :
What is missing from the T-SQL statement below for ...
Next > :
You're designing a new SQL Server 2012 table t ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
You're designing a new SQL Server 2012 table that will hold millio ...
As part of a new HR project you're creating several stored procedu ...
Which word is missing from the following statement to create a stored ...
You need to write a new query that will return names from the employee ...
You're designing a new query that will return all of the medical r ...
What is wrong with the T-SQL batch statement below: @find varchar(3 ...
SQL Server 2012 uses the standard four-part naming convention when ref ...
You're creating a new query that will select rows from a products ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...