ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Explain different isolation levels?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Explain different isolation levels?
Answer
# 1
An isolation level determines the degree of isolation of 
data between concurrent transactions. The default SQL 
Server isolation level is Read Committed. 

Here are the other isolation levels (in the ascending order 
of isolation): Read Uncommitted, Read Committed, Repeatable 
Read, Serializable
 
Is This Answer Correct ?    1 Yes 0 No
Swapna
 
  Re: Explain different isolation levels?
Answer
# 2
there are 5types of isolation level
1.ecoas
2.read commited
3.read uncommited
4.repetable read
5.synchronized
 
Is This Answer Correct ?    0 Yes 1 No
Pavan Singh
 
 
 
  Re: Explain different isolation levels?
Answer
# 3
Isolaton is the reduce the concurrency
Default 1)Read Commit
2)Read Uncommit
3)Repatable read
4) Serizable--
 
Is This Answer Correct ?    0 Yes 0 No
Hari
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is SQL server agent? SAP-Labs2
WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT  8
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?  3
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?  1
i want table name basis on column name.  2
What are the pros and cons of creating extended stored procedures?  1
how to rename the table  1
What is the appropriate number of test cases that you can write on a database? Microsoft1
What are the steps you will take, if you are tasked with securing an SQL Server? HCL1
what is the importence of the trigger in sqlserver2000? ATI1
can we call stored Procedure in Function in Sql Server 2000 and vice versa. eSoft1
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.  2
How do SQL server 2000 and XML linked?  1
how to select a field with firstletter as capital and remaining are small letters  7
Questions regarding Raiseerror?  1
What is normalization and its forms? Challenger-Financial3
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  1
is there more the two primary key in a single table? Systematix20
Difference Between varchar and nvarchar datatype? Satyam2
Which is best Subquery (or) joins in sql server? explain why  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com