Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

In regards to sorting, if a DISTINCT option is used in the SELECT clause of a query then ____.

Accepted Answer

A)  an ORDER BY clause can not be added 
B)  only columns in the SELECT clause can be used for sorting 
C)  only a primary sort is allowed 
D)  None of the above 
A)  an ORDER BY clause can not be added 
B)  only columns in the SELECT clause can be used for sorting 
C)  only a primary sort is allowed 
D)  None of the above

Question 4

The ____________________ symbol is used for determining whether or not a value is less than or equal to a specified search condition.

Accepted Answer

The answer of The ____________________ symbol is used for determining...

Question 5

Contents of BOOKS table
  
-Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?

Accepted Answer

A)  SELECT * FROM books WHERE retail >38 SORT BY retail; 
B)  SELECT * FROM books WHERE retail >38 SORTED BY retail; 
C)  SELECT * FROM books WHERE retail >38 ORDERED BY retail; 
D)  SELECT * FROM books WHERE retail >38 ORDER BY retail; 
A)  SELECT * FROM books WHERE retail >38 SORT BY retail; 
B)  SELECT * FROM books WHERE retail >38 SORTED BY retail; 
C)  SELECT * FROM books WHERE retail >38 ORDERED BY retail; 
D)  SELECT * FROM books WHERE retail >38 ORDER BY retail;

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ logical operator is evaluated first in a sequence of logical operators.

Accepted Answer

The answer of The ____________________ logical operator is evaluated first...

Question 10

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?

Accepted Answer

A)  SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1007; 
B)  SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE 1_7%; 
C)  SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1_7%; 
D)  SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE '1_7%'; 
A)  SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1007; 
B)  SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE 1_7%; 
C)  SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1_7%; 
D)  SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE '1_7%';

Question 11

When performing a search on a(n) ____________________ column, the search condition does not need to be enclosed in single quotation marks.

Accepted Answer

The answer of When performing a search on a(n) ____________________...

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

If there is an exact match between the data used for a primary sort, a(n) ____ can be used to determine the sequence used to display the data.

Accepted Answer

A)  secondary sort 
B)  alternative sort 
C)  alternate sort 
D)  supplemental sort 
A)  secondary sort 
B)  alternative sort 
C)  alternate sort 
D)  supplemental sort

Question 15

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

Accepted Answer

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

Question 16

What is the purpose of the ORDER BY clause?

Accepted Answer

The ORDER BY clause is used to

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

The ____________________ symbol is used to represent one or more characters in a search pattern.

Accepted Answer

%
percent

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

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

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

In regards to sorting, if a DISTINCT option is used in the SELECT clause of a query then ____.

The ____________________ symbol is used for determining whether or not a value is less than or equal to a specified search condition.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?

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

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.

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

The ____________________ logical operator is evaluated first in a sequence of logical operators.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?

When performing a search on a(n) ____________________ column, the search condition does not need to be enclosed in single quotation marks.

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

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

If there is an exact match between the data used for a primary sort, a(n) ____ can be used to determine the sequence used to display the data.

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

What is the purpose of the ORDER BY clause?

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

The ____________________ symbol is used to represent one or more characters in a search pattern.

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

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

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 IN logical operator is similar to using OR‾\underline{OR}OR​ . _________________________

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

In regards to sorting, if a DISTINCT option is used in the SELECT clause of a query then ____.

The ____________________ symbol is used for determining whether or not a value is less than or equal to a specified search condition.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?

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

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.

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

The ____________________ logical operator is evaluated first in a sequence of logical operators.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?

When performing a search on a(n) ____________________ column, the search condition does not need to be enclosed in single quotation marks.

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

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

If there is an exact match between the data used for a primary sort, a(n) ____ can be used to determine the sequence used to display the data.

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

What is the purpose of the ORDER BY clause?

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

The ____________________ symbol is used to represent one or more characters in a search pattern.

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

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

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

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

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

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