Ch. 8 Flashcards Preview

Oracle 11g SQL > Ch. 8 > Flashcards

Flashcards in Ch. 8 Deck (12):
1

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

Selection

2

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

WHERE clause

3

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

ORDER BY clause

4

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

Mathematical comparison operators

5

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

Condition

6

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

Comparison Operator

7

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

Like

8

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

Wildcard characters

9

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

ESCAPE

10

What is the order in which operators are resolved?

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

11

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

NULL value

12

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

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