Study tips 1z0-870

Which of the following is not a group function?

"A condition representing an outer join cannot be linked to another condition by using the OR logical operator."

Aggregate functions are also known as _________ functions.

Which of the following group functions will you use to evaluate the mean and median values for a set of data?

Which of the following operators evaluates to the value "true" if exactly one of the two arguments or expressions has the value "true"?

"All group functions except COUNT (*) and GROUPING ignore NULL values."

"A self join is performed by using different table aliases for the same table."

Which of the following operators is used to check if field values are included in a specified commadelimited list?

Which of the following is the default type of join?

Which of the following clauses specifies the join condition when using the ANSI join syntax?