1.
Which of the following is not a group function?
2.
Which group functions can be used for any data type?
3.
Which of the following functions can accept a date value as an argument?
4.
Which of the following functions is used to find the mean of an expression or the mean of the values returned by a SELECT statement?
5.
Which of the following joins is used to join a table to itself?
6.
Identify whether the given statement is true or false.
"The HAVING clause cannot be used without an associated GROUP BY clause in a SELECT statement."
7.
Identify whether the given statement is true or false.
"The IN operator cannot be used in a condition that involves an outer join."
8.
Identify whether the given statement is true or false.
"The GROUP BY clause must use column names, as column aliases cannot be used in it."
9.
Which of the following can be used to calculate the number of joins?
10.
All of the following are operators used in MySQL except for which one?