Deck 8: Restricting Rows and Sorting Data

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

​Comparison operators are used to combine search conditions.

Question 6

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

Question 7

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

Question 8

Although Oracle12c 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 9

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

Question 10

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

Question 11

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

Question 12

A NULL value is the same as a blank space.​

Question 13

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

Question 14

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 15

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

Question 16

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

Question 17

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

Question 18

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 19

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

Question 20

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 21

If a date column is being used for comparison against the search condition,the search condition is enclosed in double quotation marks._________________________​

Question 22

A(n)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 23

The process of specifying that certain rows be displayed in the results of a query is known as selection._________________________​

Question 24

The <>,!=,or ^= operators can be used to search for values that are not equivalent to the specified search condition._________________________​

Question 25

The LIKE operator is used to indicate a range of values._________________________​

Question 26

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

Question 27

A search condition can be specified in a(n)SELECT clause._________________________​

Question 28

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 29

The IN logical operator is similar to using OR._________________________​

Question 30

If a numeric column is being used for comparison against the search condition,the search condition is enclosed in single quotation marks._________________________​

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

Oracle12c is case sensitive when comparing data to a search condition._________________________​

Question 39

A greater than or equal to comparison is indicated by the symbols =>._________________________​

Question 40

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

Question 41

When using a search pattern,a(n)? symbol is used to indicate exactly one character in that position._________________________​

Question 42

When sorting data,the values will be sorted in ascending order by default._________________________​

Question 43

The BETWEEN operator is used to determine the rows that match a value in a given list._________________________​

Question 44

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 45

The SORT BY clause is used for displaying the results of a query in a sorted order._________________________​

Question 46

The numeric order of columns in a SELECT clause can be referenced in the ORDER BY clause._________________________​

Question 47

The maximum number of columns that can be used to sort data is 25._________________________​

Question 48

A(n)percent sign is used in a search pattern to indicate zero,one,or more characters in a position._________________________

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

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 51

To indicate that data should be sorted in descending order,use the DESC keyword._________________________​

Question 52

The "equal to" comparison operator is used to search for NULL values._________________________​

Question 53

Which of the following is NOT a comparison operator?​

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

Question 54

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

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

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 57

When two conditions are joined by the OR keyword,both conditions must be TRUE for a record to be included in the results._________________________​

Question 58

When data is sorted in ascending order,NULL values appear first in the list._________________________​

Question 59

NOT,AND,and OR are comparison operators._________________________​

Question 60

When two conditions are joined by the AND keyword,both conditions must be FALSE for a record to be included in the results._________________________​

Question 61

​To instruct Oracle12c 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 62

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 63

To instruct Oracle12c 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 64

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 65

Which of the following is a valid logical operator?​

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

Question 66

​Which of the following is not a valid comparison operator?

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

Question 67

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 68

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 69

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 70

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

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

Question 71

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 72

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 73

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

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

Question 74

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 75

Which of the following is a valid comparison operator?​

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

Question 76

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 77

​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 78

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

Question 79

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 80

​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