Explain different isolation levels?

Answer Posted / hari

Isolaton is the reduce the concurrency
Default 1)Read Commit
2)Read Uncommit
3)Repatable read
4) Serizable--

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

594


Which Model uses the SET concept

577


Do you know data definition language, data control language and data manipulation language?

623


What is the default Port No on which SQL Server listens?

623


Explain throw statement in sql server 2008?

581






What are the export options of ssrs?

126


How can change procedure in sql server?

517


Tell me in brief how sql server enhances scalability of the database system?

522


Will the writetext statement activate a trigger?

564


What is the difference RDBMS and Graph Database?

625


What are a scheduled jobs?

532


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

603


How you can minimize the deadlock situation?

547


What is use of dbcc commands?

622


Explain how would you store your query in an SSRS report or a Database server?

88