Exam 4: Single-Table Queries

When you use the ____________________ function, you must specify the column to total, and the column data type must be numeric.

In SQL, the ____ symbol is used as a wildcard to represent any collection of characters.

You cannot assign names to computed columns.

After the word FROM in a SELECT statement, you list any conditions (restrictions)that apply to the data you want to retrieve.

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

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

To include spaces in computed column names, enclose the computed column name in ____.

When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true.

The BETWEEN operator is an essential feature of SQL.

A(n)____________________ is simply a question represented in a way that the DBMS can understand.

In a SELECT statement, the FROM clause and the WHERE clause (when used)must appear on separate lines.

The HAVING clause is used to restrict groups.

It is possible to place one query inside another.

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

In SQL, you use the ____ command to query a database.