Which of the following is not a Table Storage specifier in MySQL?

Which is a valid declaration?

Which is not a MySQL statement?

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?

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

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

Correct syntax to turn on the global event scheduler?

Correct syntax to get the MySQL Version?

Correct syntax to create a view?

Default port for MySQL Server?

Which are valid Scalar Functions?