MYSQL DATABASE INTERVIEW QUESTIONS

What is a table in MySQL and how is it structured?

How do you create a new table in MySQL?

What are the different data types available for columns in MySQL?

How can you alter an existing table to add a new column?

What is a primary key, and how do you define it in a table?

How do you remove a column from an existing table?

What are foreign keys and how are they used in MySQL tables?

How can you create an index on a table, and why would you use one?

Explain the concept of table partitioning and its benefits.

Describe the differences between the MyISAM and InnoDB storage engines in the context of table management.