Which of the following are valid MySQL functions? Check all that apply.

Valid types of table present in MySQL?

Whichaare true for user-defined variables?

Correct syntax for updating a table using LEFT OUTER JOIN?

How do you control the max size of a HEAP table?

Which are valid Scalar Functions?

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?

Consider the following query: create table foo (id int); Which is true?

What will happen if two tables in a database are named rating and RATING?