Explain different isolation levels?

Answer Posted / juliet

isolation is a property that defines how/when the changes
made by one operation become visible to other concurrent
operations

Different isolation levels are:
Repeatable Read
Read Stability
Cursor Stability
Un commited Read

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Control Flow in SSIS

778


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

129


When to use null data driven subscription?

190


Tell me about pre-defined functions of sql?

859


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

766






write an SQL query to list the employees who joined in the month of January?

1382


What is an active database?

762


What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

131


What is normalization according to you and explain its different levels?

683


how to define testing of network layers? : Sql server database administration

657


What is advantage data architect?

682


Explain what are commit and rollback in sql?

677


Can we return Data from 4(more than 1) tables in stored procedure?

810


What is indexed view? How to create it?

759


What is difference between aggregate and analytic function?

661