Question 1

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

Question 2

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...

Question 3

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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;

Question 6

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 7

Contents of BOOKS table
  .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';" class="answers-bank-image d-inline" rel="preload" >
-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 booksWHERE profit > .6;
B)   SELECT * FROM booksWHERE (retail-cost) /cost > .60;
C)   SELECT * FROM booksWHERE (retail-cost) /cost > 60%;
D)   SELECT * FROM booksWHERE (retail-cost) /cost > '60';

Question 8

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

Question 9

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 10

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Question 15

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

Question 16

Contents of BOOKS table
 = 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" class="answers-bank-image d-inline" rel="preload" >
-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 booksWHERE pubid = 1 OR pubid = 2 OR retail >= 42;
B)   SELECT * FROM booksWHERE pubid IN (1, 2)  OR retail => 42;
C)   SELECT * FROM booksWHERE pubid = 1 AND pubid=2 OR retail >=42;
D)   both a and b

Question 17

A NULL value is the same as a blank space.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 8: Restricting Rows and Sorting Data

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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. _________________________

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

A NULL value is the same as a blank space.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified