Question 1

The ____________________ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.

Accepted Answer

BETWEEN
BE

Question 2

A(n) ____________________ identifies what must exist or a requirement that must be met before a row is included in the results of a query.

Accepted Answer

The answer of A(n) ____________________ identifies what must exist or...

Question 3

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

Accepted Answer

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

Question 4

A(n) ____________________ sort can be specified in the ORDER BY clause to indicate that if an exact match occurs during the primary sort, the alternate column listed should be used to determine the presentation sequence.

Accepted Answer

The answer of A(n) ____________________ sort can be specified in...

Question 5

____________________ is the process by which only certain rows are returned in the results of a query.

Accepted Answer

The answer of ____________________ is the process by which only...

Question 6

A(n) ____________________ value is considered the same as the absence of data.

Accepted Answer

The answer of A(n) ____________________ value is considered the same...

Question 7

What is the purpose of the WHERE clause?

Accepted Answer

The WHERE clause is used to in

Question 8

By default, a column listed in an ORDER BY clause is displayed in ____________________ order.

Accepted Answer

The answer of By default, a column listed in an...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The ____________________ logical operator is used to combine search conditions that must both be True to include a row in the results of a query.

Accepted Answer

The answer of The ____________________ logical operator is used to...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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?

Accepted Answer

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

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Contents of the ORDERS table
  
-Which of the following queries will display all orders placed in the month of March?

Accepted Answer

A)  SELECT * FROM orders WHERE orderdate LIKE '%Mar%'; 
B)  SELECT * FROM orders WHERE orderdate LIKE '_Mar_'; 
C)  SELECT * FROM orders WHERE orderdate LIKE "%Mar%"; 
D)  none of the above 
A)  SELECT * FROM orders WHERE orderdate LIKE '%Mar%'; 
B)  SELECT * FROM orders WHERE orderdate LIKE '_Mar_'; 
C)  SELECT * FROM orders WHERE orderdate LIKE "%Mar%"; 
D)  none of the above

Question 18

The ____________________ clause is used to specify the order in which the data should be presented in the results of a query.

Accepted Answer

The answer of The ____________________ clause is used to specify...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

The ____________________ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.

A(n) ____________________ identifies what must exist or a requirement that must be met before a row is included in the results of a query.

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

A(n) ____________________ sort can be specified in the ORDER BY clause to indicate that if an exact match occurs during the primary sort, the alternate column listed should be used to determine the presentation sequence.

____________________ is the process by which only certain rows are returned in the results of a query.

A(n) ____________________ value is considered the same as the absence of data.

What is the purpose of the WHERE clause?

By default, a column listed in an ORDER BY clause is displayed in ____________________ order.

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

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

The ____________________ logical operator is used to combine search conditions that must both be True to include a row in the results of a query.

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

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?

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.

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

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

Contents of the ORDERS table -Which of the following queries will display all orders placed in the month of March?

The ____________________ clause is used to specify the order in which the data should be presented in the results of a query.

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

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

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 8: Restricting Rows and Sorting Data

The ____________________ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.

A(n) ____________________ identifies what must exist or a requirement that must be met before a row is included in the results of a query.

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

A(n) ____________________ sort can be specified in the ORDER BY clause to indicate that if an exact match occurs during the primary sort, the alternate column listed should be used to determine the presentation sequence.

____________________ is the process by which only certain rows are returned in the results of a query.

A(n) ____________________ value is considered the same as the absence of data.

What is the purpose of the WHERE clause?

By default, a column listed in an ORDER BY clause is displayed in ____________________ order.

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

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

The ____________________ logical operator is used to combine search conditions that must both be True to include a row in the results of a query.

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

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?

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.

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

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

Contents of the ORDERS table -Which of the following queries will display all orders placed in the month of March?

The ____________________ clause is used to specify the order in which the data should be presented in the results of a query.

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

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

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

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

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