What is transaction server isolation?



What is transaction server isolation?..

Answer / Ravi Bhushan Mishra

Isolation in SQL Server refers to the property of a transaction ensuring that concurrent transactions do not interfere with each other. This is achieved by using isolation levels such as READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SNAPSHOT. Each level provides different levels of concurrency and data consistency.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Scalability, Availability, Integration with internet, etc.)?

1 Answers  


What is transaction server distributed transaction?

1 Answers  


What are system databases in ms sql server?

1 Answers  


What are the types of table?

1 Answers  


How to display a past time in days, hours and minutes?

1 Answers  


What do mean by xml datatype?

1 Answers  


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

1 Answers  


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1 Answers  


What do you understand by a view? What does the with check option clause for a view do?

1 Answers  


How to change location of errorlog in SQL?

2 Answers   ABC, IBM,


How to list all tables in the database using odbc_tables()?

1 Answers  


What is a select query statement in ms sql server?

1 Answers  


Categories