What is the main purpose of InnoDB over MyISAM?

What will happen if you write the following statement on the MySQL prompt? SELECT NOW();

Which query will display data from the Pers table relating to Analyst, Clerk and Salesman who joined between 1/1/2005 and 1/2/2005 ? Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005 ?

What is true regarding the SET data type?

Name of the utility used to extract NDB configuration information?

What is true regarding the TIMESTAMP data type?

Whichaare true for user-defined variables?

Valid types of table present in MySQL?

Which are valid MySQL functions?

Which will truncate all tables in a MySQL database?

Valid modes of parameters in stored routines?