Which of the following are valid Scalar Functions? Check all that apply.

Default port for MySQL Server?

Correct syntax to create a view?

Correct syntax to get the MySQL Version?

Correct syntax to turn on the global event scheduler?

Syntax to backup a database from command line?

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?

Which is not a MySQL statement?

Which is a valid declaration?

Which is not a Table Storage specifier in MySQL?