Quiz 1z0-870, MySQL 5 Certified Associate
"The HAVING clause cannot be used without an associated GROUP BY clause in a SELECT statement."
"The IN operator cannot be used in a condition that involves an outer join."
"The GROUP BY clause must use column names, as column aliases cannot be used in it."
Which of the following can be used to calculate the number of joins?
which one?
Inner join is also known as ________ join.
Which of the following functions is used to determine whether a value is odd or even?
Which of the following CANNOT be committed?
Which of the following comprises a unit of work performed within a database management system?
Which of the following options executes when BEGIN TRANS operator is called?