MYSQL DATABASE INTERVIEW QUESTIONS

What is an index in MySQL and why is it used?

Can you name the different types of indexes available in MySQL?

What is a primary key index?

What is a unique index and how does it differ from a primary key index?

How does a full-text index work in MySQL?

When would you use a spatial index in MySQL?

What are composite indexes and when should you use them?

Explain the difference between a B-tree index and a hash index in MySQL.

How can indexing negatively impact MySQL performance?

During a database certification exam, you are asked to create a full-text index and perform a search using it. What steps would you follow?