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

The property of InnoDB that enforces foreign key relationships stay intact is called . . . . . . . .

Answer & Solution
Correct Answer: Option D
This question is about InnoDB, a storage engine used in MySQL. It asks about a property that ensures the integrity of foreign key relationships. This means that the data connected through these relationships remains accurate and consistent.

Let's understand the options:
Option A: atomicity - Atomicity means that transactions either complete fully or not at all. It's about ensuring that changes are applied as a single unit.
Option B: durability - Durability guarantees that once a transaction is committed, the changes are permanently stored and survive system failures.
Option C: consistency - Consistency refers to maintaining data in a valid state according to predefined rules. It ensures that data is accurate and follows the database's constraints.
Option D: referential integrity - This is the property that specifically focuses on foreign key relationships. It ensures that data in a related table is valid and maintains the connection between the tables.

Therefore, the answer is Option D: referential integrity. It's the key property that guarantees foreign key relationships remain intact and data stays consistent.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.