Which of the statements are 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?

Default port for MySQL Server?

Correct syntax to create a view?

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?

Is the following query valid? create table foo (id int primary key auto_increment, name varchar);

Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) Subjects --------- SubjectId Subject (such as History, Geography, Mathematics etc) Authors -------- AuthorId AuthorName Country Which is the query to determine the Authors who have written at least 1 book with a popularity rating of less than 5?