MYSQL DATABASE INTERVIEW QUESTIONS

What is a primary key in MySQL?

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

Can a table have more than one primary key? Why or why not?

What is a composite primary key, and how do you create one in MySQL?

What are the differences between a primary key and a unique key in MySQL?

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

Explain the impact of primary keys on indexing and query performance in MySQL.

How does MySQL handle primary key constraints in a replication environment?

Can a primary key be changed in MySQL? If so, how?

Describe a scenario where choosing the correct primary key is crucial for database design, and explain the consequences of a poor primary key choice.