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

• 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
• 8 years agoHelpfull: Yes(6) No(0)
• option b) is correct
• 8 years agoHelpfull: Yes(1) No(0)
• ACID properties:
  Atomicity
  Consistency
  Isolation:No transaction can interfere in the end result of another transaction
  Durability
  
• 8 years agoHelpfull: Yes(0) No(0)
• b) is correct answer.
• 6 years agoHelpfull: Yes(0) No(0)
• 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
• 6 years agoHelpfull: Yes(0) No(0)
• b) is correct as every transaction should get a feel that is isolated and separated from the other one.
• 6 years agoHelpfull: Yes(0) No(0)
• b bcz no process should interfere withother
• 3 years agoHelpfull: Yes(0) No(0)