MYSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the CREATE TABLE statement in MySQL?

How do you create a simple table with columns for an ID, name, and age?

What is a primary key, and how do you define it in the CREATE TABLE statement?

How do you create a table with a foreign key constraint in MySQL?

How can you specify default values for columns when creating a table?

How do you create a table with a unique constraint on a column?

How do you create a table with a composite primary key in MySQL?

How can you create a table with an auto-increment column and a foreign key constraint?

How do you create a table with a CHECK constraint in MySQL?

How do you create a partitioned table in MySQL, and what are its benefits?