How would you change a table to InnoDB?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How would you change a table to InnoDB?

ALTER TABLE techinterviews_questions ENGINE innodb;

(Continued on next question...)

Other Job Interview Questions

• How do you add three minutes to a date?
• You wrote a search engine that should retrieve 10 results at a time, but at the same time you’d like to know how many rows there’re total. How do you display that to the user?
• MySQL - Keeping Your Password Secure
• Explain the difference between BOOL, TINYINT and BIT.
• How MySQL Optimizes LIMIT
• What is SERIAL data type in MySQL?
• What’s the default port for MySQL Server?
• How would you select all the users, whose phone number is null?
• Functionality Missing from MySQL - Sub-selects
• Explain advantages of MyISAM over InnoDB?
• More...