7,074 views

3 Answers

Best answer
21 votes
21 votes

Answer is Serializable ---Highest isolation level and Lowest one is Read Uncommitted 

The Isolation level are defined for transaction :

We will see what violation can happen with each isolation level : violation are Dirty read , Non repeatable read, Phantom .

The first one is Read Uncommitted : So here Dirty read , Non repeatable read, Phantom . all are possible  

The second One is  Read Committed : It reads the data after the another transaction is committed But it doesnt guarantee That the next time it will read the same data value then it will get same old value .. Dirty read--Not possible  , Non repeatable read--Possible , Phantom-- Possible .

Third one : Repeated Read : : It reads the data after the another transaction is committed But it  guarantee That the next time it will read the same data value then it will get same old value .. Dirty read--Not possible  , Non repeatable read--not possible, Phantom-- Possible .

Fourth One is : Serializable : It is highest and toughest isolation level . It will give always Consistent result . It would have schedules equivalent to Serial Schedules .Dirty read--Not possible  , Non repeatable read--Possible , Phantom-- Not Possible .

 .

selected by
2 votes
2 votes
c) Committed read

Isolation is for concurrency management of DBMS.

And concurrency control violates serializability

https://vladmihalcea.com/2014/12/23/a-beginners-guide-to-transaction-isolation-levels-in-enterprise-java/

Am I correct?
edited by
Answer:

Related questions

8 votes
8 votes
5 answers
1
makhdoom ghaya asked May 2, 2016
7,257 views
Embedded pointer providesA secondary access pathA physical record keyAn inverted indexA primary key
8 votes
8 votes
2 answers
2
makhdoom ghaya asked Apr 27, 2016
5,364 views
The physical location of a record determined by a formula that transforms a file key into a record location isHashed file$B$-Tree fileIndexed fileSequential file
8 votes
8 votes
2 answers
3
8 votes
8 votes
1 answer
4