What is the isolation property of transactions?

Solution (By Examveda Team)

In a database, a transaction is a sequence of operations that are treated as a single unit. Imagine you're transferring money from one account to another. This whole process, from checking your balance to confirming the transfer, is considered a transaction.
Now, the isolation property ensures that multiple transactions happening at the same time don't interfere with each other.
Think of it like this: You're at the bank, and someone else is doing a transaction at the same time. The isolation property makes sure that your transaction doesn't get mixed up with theirs, and your money ends up in the right place.
So, the correct answer is Option C: one transaction does not affect the other.
Let's look at why the other options are incorrect:
Option A: statements form a logic unit - This describes the atomicity property of transactions, meaning all operations within a transaction happen or none of them do.
Option B: database remains consistent - This describes the durability property, ensuring changes made by a successful transaction are permanently stored.
Option D: transaction effects are recorded permanently - This again relates to the durability property.
Therefore, the isolation property specifically focuses on preventing conflicts between concurrent transactions.