Latest DBMS Aptitude Question SOLUTION: What does isolation in Acid rules for transaction in database mean? a)either the effects of whole transaction is reflected on database or database is rolled back to its original st

• Placement Papers
• /
• DBMS
• /
• Category

DBMS Question Papers:

(#M40155921) DBMS Category question Keep an EYE

What does isolation in Acid rules for transaction in database mean?
a)either the effects of whole transaction is reflected on database or database is rolled back to its original state
b)No transaction can interfere in the end result of another transaction
c)effects of a successful transaction must persist in a database
d)Every individual transaction must leave database in a cosistent state .maintaining the integrity of the database

Asked In DBMS Tushar Borole (8 years ago)

Unsolved Read Solution (7)

Is this Puzzle helpful?   (219)   (95) Submit Your Solution

Read Solution (7) :

ABHISHEK SINGH  (8 years ago)

Option (a) is a case of Atomicity property
Option (b) is a case of ISOLATION property
Option (c) is a case of Durability property
Option (d) is a case of Consistency property

Is this solution Helpfull? Yes (6) | No   

Harshit Sharma  (8 years ago)

option b) is correct

Is this solution Helpfull? Yes (1) | No   

P Sharanya  (8 years ago)

ACID properties:
Atomicity
Consistency
Isolation:No transaction can interfere in the end result of another transaction
Durability

Is this solution Helpfull? Yes | No   

Divya Batra  (6 years ago)

b) is correct answer.

Is this solution Helpfull? Yes | No   

Adi  (6 years ago)

D. as it involves - atomicity(complete transaction should be done else not which is solved by saying that the system is consistent), Consistency(already stated), Isolation(as suggested with the formation of the sentence in the question where it states, individual transaction which points to the fact that the transactions are not interfering w/ each other), Durability(the integrity of the system is maintained only when the resultants of each transaction are stored correctly).

So yeah 'D' is the answer

Is this solution Helpfull? Yes | No   

Shreya  (6 years ago)

b) is correct as every transaction should get a feel that is isolated and separated from the other one.

Is this solution Helpfull? Yes | No   

Supriya Rao  (3 years ago)

b bcz no process should interfere withother

Is this solution Helpfull? Yes | No   

Please Login to Read Solution.