ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

The 'A' in the ACID property of transactions is . . . . . . . .

Answer & Solution
Correct Answer: Option D
This question is about the ACID properties of transactions in MySQL. ACID stands for Atomicity, Consistency, Isolation, and Durability.

The 'A' in ACID stands for Atomicity. This means that a transaction is treated as a single unit of work. Either all the changes within the transaction are completed successfully, or none of them are.

Let's break it down:
* Atomicity: Think of a transaction like a bank transfer. You want to transfer $100 from your checking account to your savings account. Atomicity ensures that both parts of this transaction happen together. If the money is deducted from your checking account but doesn't reach your savings account, the transaction fails.
* Consistency: Ensures that data remains consistent even after the transaction. In the bank transfer example, your total money remains the same even after the transfer.
* Isolation: Ensures that different transactions don't interfere with each other. If multiple users are trying to access the same data, isolation makes sure each user sees a consistent view of the data.
* Durability: Once a transaction is committed, the changes are permanently stored in the database. The data won't be lost even if the database crashes.

Therefore, the correct answer is Option D: Atomicity.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.