Exam 4: Single-Table Queries

The COUNT function only applies to columns with numeric values.

The UNIQUE operator eliminates duplicate values in a query.

When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.

Compare the WHERE and HAVING clauses.

____________________ creates groups of rows that share some common characteristic.

An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.

Aggregate functions apply to groups of rows.

In a nested query, the outquery is evaluated first .

The ____ wildcard symbol represents any individual character.

You form compound conditions by connecting two or more simple conditions using the ____ operators.

You use the ____ clause to list data in a specific order.

The MIN function determines the minimum value in a row.

Preceding a condition by the NOT operator reverses the truth of the original condition.

Sometimes a condition involves a column that can accept null values.

You can use computed columns in comparisons.

When the ____________________ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.

The ____________________ operator finds rows that contain a null value in the specified column.

The ____ function determines the number of rows in a table.

Which of the following operators can be used for a column computation?

Describe simple and compound conditions.