Exam 4: Single-Table Queries

When you use the ____ function, you can use the asterisk (*) to represent any column.

You can use computed columns in comparisons.

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

When data is sorted on two columns, the more important column is called the major sort key.

SQL requires that you follow special formatting rules.

You use the ____________________ clause to retrieve rows that satisfy some condition.

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

The UNIQUE operator eliminates duplicate values in a query.

It is possible to place one query inside another.

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

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

Aggregate functions apply to groups of rows.

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

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

When you query a database, there is a defined order in which the results are displayed.

You can assign a name to a computed column by following the computation with the word ____________________ and the desired name.

The WHERE clause is used to limit the rows that are included in a query's result.

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

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

To sort records in descending order, follow the name of the sort key with the REVERSE operator.