MYSQL DATABASE INTERVIEW QUESTIONS

What is a foreign key in MySQL?

How do you define a foreign key when creating a table in MySQL?

What are the benefits of using foreign keys in MySQL?

How do you add a foreign key to an existing table in MySQL?

What is the purpose of the ON DELETE CASCADE clause in a foreign key definition?

How does MySQL handle foreign key constraints when updating data?

Explain the differences between ON DELETE SET NULL and ON DELETE RESTRICT.

What are the potential performance implications of using foreign keys in MySQL?

Can you use foreign keys to enforce complex business rules? Provide an example.

Describe a scenario where foreign key constraints are critical to maintaining data integrity, and explain how you would implement it in MySQL.