Explain advantages of InnoDB over MyISAM?

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

(Continued from previous question...)

Explain advantages of InnoDB over MyISAM?

Row-level locking, transactions, foreign key constraints and crash recovery.

(Continued on next question...)

Other Job Interview Questions

• MySQL - Drawbacks to Creating Large Numbers of Tables in the Same Database
• What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id)
• Adding New User Privileges to MySQL
• Explain the difference between FLOAT, DOUBLE and REAL.
• MySQL is Portability
• How are ENUMs and SETs represented internally?
• How to connecting to the MySQL Server
• What’s the difference between CHAR_LENGTH and LENGTH?
• What does –i-am-a-dummy flag to do when starting MySQL?
• What’s the difference between Unix timestamps and MySQL timestamps?
• More...