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

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

Answer & Solution
Correct Answer: Option D
The ACID properties are a set of important rules that ensure the reliability of database transactions. These rules guarantee that data changes are applied correctly and consistently.

Let's break down the ACID acronym:

A - Atomicity: All changes within a transaction are applied together, or none of them are applied. If one part fails, the entire transaction is rolled back. Think of it as an all-or-nothing deal.

C - Consistency: Transactions maintain the integrity of the database. They ensure that data remains valid and meets predefined rules before and after the transaction.

I - Isolation: Transactions happen independently of each other. This means one transaction won't see the partial results of another transaction until it's fully committed.

D - Durability: Once a transaction is committed, the changes are permanent and survive system failures.

In this question, the correct answer is Option D: Consistency.

So, the 'C' in ACID stands for Consistency, ensuring that database operations maintain data integrity throughout the transaction process.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.