Deck 8: Restricting Rows and Sorting Data

Question 1

Search conditions for data contained in numeric columns must be enclosed in single quotation marks.

Answer 1

False

Question 2

Retrieving only specific rows from a table is a process known as selection.

Answer 2

True

Question 3

The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.

Answer 3

True

Question 4

The IN comparison operator is used when searching for a pattern of characters.

Question 5

A NULL value is the same as a blank space.

Question 6

The BETWEEN...AND comparison operator can be used to specify a range of values as a search condition.

Question 7

When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as FALSE to be included in the query results.

Question 8

In a WHERE clause, logical operators are evaluated before comparison operators.

Question 9

Logical operators are evaluated in the order of NOT, AND, and OR.

Question 10

Using the OR logical operator to combine search conditions based upon the same column is the same as using the IN comparison operator.

Question 11

NOT, ALL, and OR are all considered logical operators.

Question 12

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks.

Question 13

When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as True to be included in the query results.

Question 14

Although Oracle11g is not case sensitive in regards to keywords, table names, and column names, it is case sensitive when comparing search conditions to the data contained in a database table.

Question 15

Retrieving only certain rows from a table is known as projection.

Question 16

The percent sign (%) is used in a search pattern to indicate "exactly one character in this position".

Question 17

Comparison operators are used to combine search conditions.

Question 18

The percent sign (%) and asterisk (*) symbols can be used with the LIKE comparison operator to create a search pattern.

Question 19

The underscore symbol (_) is used in a search pattern to indicate "exactly one character in this position".

Question 20

When two conditions are joined by the AND logical operator, only one of the conditions must be True to be included in the query results.

Question 21

The process of specifying that certain rows be displayed in the results of a query is known as $\underline { \text { selection } }$ . _________________________

Question 22

Oracle11g $\underline {\text { is case sensitive } }$ when comparing data to a search condition. _________________________

Question 23

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.

Question 24

The $\underline { \text { LIKE } }$ operator is used to indicate a range of values. _________________________

Question 25

A search condition can be specified in a(n) $\underline { \text { SELECT } }$ clause. _________________________

Question 26

The <>, !=, or ^= operators can be used to search for values that are $\underline { \text { not equivalent } }$ to the specified search condition. _________________________

Question 27

A greater than or equal to comparison is indicated by the symbols $\underline {=> }$ . _________________________

Question 28

By default, query results are sorted in ascending order based upon the column specified in the ORDER BY clause.

Question 29

The SORT BY clause is used to present query results in a specific order.

Question 30

A(n) $\underline { \text { clause } }$ identifies what must exist or a requirement that must be met for a record to be included in the results of a query. _________________________

Question 31

If a numeric column is being used for comparison against the search condition, the search condition $\underline { \text { is enclosed } }$ in single quotation marks. _________________________

Question 32

When sorted in descending order, NULL values will be listed first in the results, unless the user specifies otherwise.

Question 33

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table.

Question 34

To find rows containing a NULL value in a specified column, you must use the search condition of = NULL.

Question 35

Including the keywords NULLS FIRST in the ORDER BY clause will result in NULL values appearing first in the results, regardless of the specified sort sequence.

Question 36

The maximum number of columns that can be used to sort the results of a query is 52.

Question 37

If a date column is being used for comparison against the search condition, the search condition is enclosed in $\underline { \text { double } }$ quotation marks. _________________________

Question 38

The first column listed in an ORDER BY clause is considered the primary sort.

Question 39

The IN logical operator is similar to using $\underline{OR}$ . _________________________

Question 40

An ORDER BY clause can reference a column to be used for sorting based upon its position in the SELECT clause.

Question 41

When two conditions are joined by the $\underline{OR}$ keyword, both conditions must be True for a record to be included in the results. _________________________

Question 42

Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $24.00?

A) LIKE
B) BETWEEN
C) >
D) >=

Question 43

The $\leq$ symbol is used to search for records containing a value that is less than or equal to the stated search condition. _________________________

Question 44

The maximum number of columns that can be used to sort data is $\underline { 25 }$ _________________________

Question 45

Which of the following is NOT a comparison operator?

A) >=
B) BETWEEN...AND
C) =
D) NOT

Question 46

If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____.

A) double quotation marks (" ")
B) single quotation marks (' ')
C) parentheses ( )
D) none of the above

Question 47

A(n) ____ is used to indicate how data should relate to a given search condition.

A) comparison operator
B) logical operator
C) search pattern
D) criteria

Question 48

The $\underline { \text { numeric order } }$ of columns in a SELECT clause can be referenced in the ORDER BY clause. _________________________

Question 49

The process of retrieving only certain rows based upon a specified condition is known as ____.

A) selection
B) projection
C) retrieval
D) derivation

Question 50

When using a search pattern, a(n) $\underline { ? }$ symbol is used to indicate exactly one character in that position. _________________________

Question 51

When two conditions are joined by the AND keyword, both conditions must be $\underline { \text { FALSE } }$ for a record to be included in the results. _________________________

Question 52

The $\underline {\text { BETWEEN } }$ operator is used to determine the rows that match a value in a given list. _________________________

Question 53

NOT, AND, and OR are $\underline {\text { comparison } }$ operators. _________________________

Question 54

When data is sorted in ascending order, NULL values appear $\underline { \text { first } }$ in the list. _________________________

Question 55

Which of the following clauses is used to restrict the rows returned by a query?

A) SELECT
B) FROM
C) WHERE
D) ORDER BY

Question 56

To indicate that data should be sorted in descending order, use the $\underline {\text { DESC } }$ keyword. _________________________

Question 57

A(n) $\underline { \text { percent } }$ sign is used in a search pattern to indicate zero, one, or more characters in a position. _________________________

Question 58

The $\underline { \text { SORT BY } }$ clause is used for displaying the results of a query in a sorted order. _________________________

Question 59

When sorting data, the values will be sorted in $\underline { \text { ascending } }$ order by default. _________________________

Question 60

The $\underline {\text { "equal to" }}$ comparison operator is used to search for NULL values. _________________________

Question 61

Which of the following clauses is used to indicate a particular sort sequence for presenting query results?

A) SELECT
B) SORT BY
C) WHERE
D) ORDER BY

Question 62

To instruct Oracle11g to sort data in descending order, enter ____ after the column name in the WHERE clause.

A) D
B) DES
C) DESC
D) none of the above

Question 63

Which of the following operators can be used to combine search conditions?

A) AND
B) =
C) IS NOT NULL
D) none of the above

Question 64

Which of the following search conditions can be used to identify records that have data stored in a column named ColB?

A) ColB IS NOT NULL
B) ColB ^= NULL
C) ColB != NULL
D) all of the above

Question 65

Which of the following search patterns would find dates occurring only in the year 2003?

A) %03%
B) *03
C) %03
D) _03%

Question 66

Which of the following is not a valid comparison operator?

A) =>
B) <>
C) ^=
D) none of the above

Question 67

When the WHERE clause contains multiple types of operators, which of the following is resolved last?

A) arithmetic operations
B) comparison operators
C) logical operators
D) search patterns

Question 68

When sorting the results in descending order, which of the following values will be presented first in the output?

A) numeric
B) character
C) NULL
D) date

Question 69

When sorting the results in ascending order, which of the following values will be presented first in the output?

A) numeric
B) character
C) NULL
D) date

Question 70

When the WHERE clause contains multiple types of operators, which of the following is resolved first?

A) arithmetic operations
B) comparison operators
C) logical operators
D) union operators

Question 71

When sorting the results in descending order, which of the following values will be presented last in the output?

A) numeric
B) character
C) NULL
D) date

Question 72

To instruct Oracle11g to sort data in ascending order, enter ____ after the column name in the ORDER BY clause.

A) ASC
B) A
C) ASCENDING
D) either a or c

Question 73

Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?

A) ColB = NULL
B) ColB IS NOT NULL
C) ColB IS NULL
D) ColB = ' '

Question 74

Which of the following is a valid comparison operator?

A) !=
B) IN
C) ^=
D) all of the above

Question 75

Which of the following search patterns could be used to find the word HELLO in Oracle11g?

A) %H%
B) HEL*
C) _EL*
D) %HEL?O

Question 76

Which of the following is a valid logical operator?

A) NOT
B) AND
C) OR
D) all of the above

Question 77

Which of the following symbols is a wildcard character that can represent any number of characters in a WHERE clause?

A) asterisk (*)
B) underscore (_)
C) question mark (?)
D) percent sign (%)

Question 78

When sorting the results in ascending order, which of the following values will be presented last in the output?

A) character
B) numeric
C) NULL
D) date

Question 79

Which of the following operators is used when the criteria is based upon a search pattern?

A) AND
B) LIKE
C) IS NULL
D) BETWEEN...AND

Question 80

Which of the following operators can be used to retrieve rows containing NULL values in a specific column?

A) =
B) LIKE
C) NOT
D) none of the above