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
Do you know the cursor optimization tips?
What are the different types of backups avaialabe in sql server 2005?
What is the purpose of data source?
How to filter out duplications in the returning rows in ms sql server?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Why use view instead of a table?
what is the difference between count(*) and count(1) ?
What command is used to create a database in the sql server and how?
What is the difference between varchar and varchar types?
Explain various On-Delete options in a DB table. Which is the default option?
How to move database physical files in ms sql server?
What is right outer join in sql server joins?
What is pessimistic concurrency?
How the authentication mode can be changed?
How to add a new dsn with the odbc driver for sql server?
