1.
Which of the following is not a group function?
2.
Identify whether the given statement is true or false.
"A condition representing an outer join cannot be linked to another condition by using the OR logical operator."
3.
Aggregate functions are also known as _________ functions.
4.
Which of the following group functions will you use to evaluate the mean and median values for a set of data?
5.
Which of the following operators evaluates to the value "true" if exactly one of the two arguments or expressions has the value "true"?
6.
Identify whether the given statement is true or false. "All group functions except COUNT (*) and GROUPING ignore NULL values."
7.
Identify whether the given statement is true or false.
"A self join is performed by using different table aliases for the same table."
8.
Which of the following operators is used to check if field values are included in a specified commadelimited list?
9.
Which of the following is the default type of join?
10.
Which of the following clauses specifies the join condition when using the ANSI join syntax?