Examveda

Foreign keys cannot handle deletes and updates.

A. True

B. False

Answer: Option B

Solution (By Examveda Team)

This question is about foreign keys in MySQL. Foreign keys are used to connect different tables in a database. They ensure that data in one table is consistent with data in another.

The question asks whether foreign keys can handle deletes and updates.

Let's break it down:
- Deletes: When you delete a record in a table with a foreign key, MySQL can enforce the deletion. This means that if a record in the parent table is deleted, any related records in the child table will be deleted as well.
- Updates: Similarly, when you update a record in the parent table, MySQL can enforce the update. This means that if a value is changed in the parent table, the corresponding value in the child table will also be updated.

So, the answer to the question is False. Foreign keys can handle deletes and updates by enforcing consistency between tables.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous