Mysql Interview Questions

What is Relational Database Design Patterns?
What is Federated storage engine?
What is Merge storage engine?
What is USE INDEX, FORCE INDEX ?
How will u optimize query?
Ex: it will take 1 hours, but we need it in 20 min ?
Difference b/w DESCRIBE and Explain ?
What is horizontal partition?
Steps for migrating from mysql 4 to myqsl 5?
What is the difference between left join, inner join , Cross join?
cross join : records in table 1 * records in table 1