Exam 4: Single-Table Queries

____________________ creates groups of rows that share some common characteristic.

SQL has special functions, called ____________________ functions, to calculate sums, averages, counts, maximum values, and minimum values.

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

The GROUP BY clause sorts the data in a particular order.

How do you construct the SELECT query?

The ____________________ operator uses one or more wildcard characters to test for a pattern match.

Describe simple and compound conditions.

The MIN function determines the minimum value in a column.

A query is a question represented in a way that the DBMS can understand.

A(n) ____________________ clause provides a concise way of phrasing certain conditions.

The inner query in a nested query is called a(n) ____________________.

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

Oracle supports only the <> version of the "not equal to" comparison operator.

A(n) ____________________ column is a column that does not exist in the database but can be computed using data in the existing columns.

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

The ____ clause lets you group data on a particular column.

Compare the WHERE and HAVING clauses.

All SELECT statements require a WHERE clause.

When you need to sort data on two columns, the less important column is called the ____ sort key.

It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.