Ch. 8

Question 1

________ is the process referred when you want to see only records meeting certain conditions.

Answer 1

Selection

Question 2

_____ _______ is used to specify conditions that must be true for a record to be included in query results.

Answer 2

WHERE clause

Question 3

_____ ___ ______ is used to specify the sorted order for displaying query results.

Answer 3

ORDER BY clause

Question 4

_________ _______ ______ are used to indicate how a record should relate to a specific search value.

Answer 4

Mathematical comparison operators

Question 5

A _______ identifies what must exist or a requirement that must be met for a record to be included in the results.

Answer 5

Condition

Question 6

A _______ _______ indicates how data should relate to the search value, such as >.

Answer 6

Comparison Operator

Question 7

The ____ operator is unique, in that its used with wildcard characters to search for patterns.

Answer 7

Like

Question 8

_______ _______ are used to represent one or more alphanumeric characters.

Answer 8

Wildcard characters

Question 9

The LIKE operator includes the _______ option for indicating when wildcard symbols should be used as literals rather than translated as wildcard characters.

Answer 9

ESCAPE

Question 10

What is the order in which operators are resolved?

Answer 10

1. Arithmetic operations
2. Comparison operators (, =, LIKE)
3. Logical operatoras [in this order (NOT, AND, OR)}

Question 11

A ______ ______ means no value has been stored in that field.

Answer 11

NULL value

Question 12

When sorting in ascending order, values are listed in what order?

Answer 12

1. Bland and special characters
2. Numeric values
3. Character values (uppercase first)
4. NULL values