Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ comparison operator is used when the search condition includes a search pattern.

Accepted Answer

The answer of The ____________________ comparison operator is used when...

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A NULL value is the same as a blank space.

Accepted Answer

A) True 
 B)False

Question 9

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?

Accepted Answer

A)  SELECT * FROM orders WHERE customer# = 1020 OR shipdate = NULL; 
B)  SELECT * FROM orders WHERE customer# = 1020 AND shipdate IS NULL; 
C)  SELECT * FROM orders WHERE customer# = 1020 OR shipdate IS NULL; 
D)  SELECT * FROM orders WHERE customer# = 1020 AND shipdate = NULL; 
A)  SELECT * FROM orders WHERE customer# = 1020 OR shipdate = NULL; 
B)  SELECT * FROM orders WHERE customer# = 1020 AND shipdate IS NULL; 
C)  SELECT * FROM orders WHERE customer# = 1020 OR shipdate IS NULL; 
D)  SELECT * FROM orders WHERE customer# = 1020 AND shipdate = NULL;

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

When sorting the results in descending 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 16

Contents of BOOKS table
  
-Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit?

Accepted Answer

A)  SELECT * FROM books
WHERE profit > .6; 
B)  SELECT * FROM books
WHERE (retail-cost)/cost > .60; 
C)  SELECT * FROM books
WHERE (retail-cost)/cost > 60%; 
D)  SELECT * FROM books
WHERE (retail-cost)/cost > '60'; 
A)  SELECT * FROM books
WHERE profit > .6; 
B)  SELECT * FROM books
WHERE (retail-cost)/cost > .60; 
C)  SELECT * FROM books
WHERE (retail-cost)/cost > 60%; 
D)  SELECT * FROM books
WHERE (retail-cost)/cost > '60';

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Contents of BOOKS table
  
-Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

Accepted Answer

A)  SELECT * FROM books
WHERE pubid = 1 OR pubid = 2 OR retail >= 42; 
B)  SELECT * FROM books
WHERE pubid IN (1, 2) OR retail => 42; 
C)  SELECT * FROM books
WHERE pubid = 1 AND pubid=2 OR retail >=42; 
D)  both a and b 
A)  SELECT * FROM books
WHERE pubid = 1 OR pubid = 2 OR retail >= 42; 
B)  SELECT * FROM books
WHERE pubid IN (1, 2) OR retail => 42; 
C)  SELECT * FROM books
WHERE pubid = 1 AND pubid=2 OR retail >=42; 
D)  both a and b

Question 20

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.

Accepted Answer

The answer of The ____________________ keywords can be included in...

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

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

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

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

The ____________________ comparison operator is used when the search condition includes a search pattern.

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

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

A NULL value is the same as a blank space.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?

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

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

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.

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

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

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit?

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

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.

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

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

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

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

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

The ____________________ comparison operator is used when the search condition includes a search pattern.

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

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

A NULL value is the same as a blank space.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?

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

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

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.

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

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

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit?

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

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.

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 $\underline {\text { BETWEEN } }$ operator is used to determine the rows that match a value in a given list. _________________________

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

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

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