What are the valid modes of parameters in stored routines? Check all that apply.

Which will truncate all tables in a MySQL database?

Which are valid MySQL functions?

Valid types of table present in MySQL?

Whichaare true for user-defined variables?

Correct syntax for updating a table using LEFT OUTER JOIN?

Name of the utility used to extract NDB configuration information?

What is true regarding the SET data type?

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 will happen if you write the following statement on the MySQL prompt? SELECT NOW();

Main purpose of InnoDB over MyISAM?