Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ symbol is used for determining whether or not a value is greater than a specified search condition.​

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Contents of the ORDERS table
  3; B)  ​SELECT * FROM orders WHERE shipdate-orderdate >= 3; C)  ​SELECT * FROM orders WHERE NOT shipdate-orderdate => 3; D)  ​SELECT * FROM orders WHERE NOT shipdate-orderdate >= 3;" class="answers-bank-image d-inline" rel="preload" >
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders that were not shipped for at least three days after the order was received?​

Accepted Answer

A)   ​SELECT * FROM orders WHERE shipdate-orderdate => 3;
B)   ​SELECT * FROM orders WHERE shipdate-orderdate >= 3;
C)   ​SELECT * FROM orders WHERE NOT shipdate-orderdate => 3;
D)   ​SELECT * FROM orders WHERE NOT shipdate-orderdate >= 3;

Question 5

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 6

Which of the following is NOT a comparison operator?​

Accepted Answer

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

Question 7

Contents of BOOKS table
 = '01-JAN-01' AND pubdate  ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books published in 2001?​

Accepted Answer

A)   ​SELECT * FROM booksWHERE pubdate BETWEEN '01-JAN-01' AND '31-DEC-01';
B)   ​SELECT * FROM booksWHERE pubdate LIKE '%01';
C)   ​SELECT * FROM booksWHERE pubdate >= '01-JAN-01' AND pubdate 
D)   ​all of the above

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

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 (%)

Question 12

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

Accepted Answer

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

Exam 8: Restricting Rows and Sorting Data

Which of the following is NOT a comparison operator?

Correct Answer
verified

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 published in 2001?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders that were not shipped for at least three days after the order was received?

Correct Answer
verified

Exam 8: Restricting Rows and Sorting Data

Which of the following is NOT a comparison operator?​

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 published in 2001?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ symbol is used for determining whether or not a value is greater than a specified search condition.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders that were not shipped for at least three days after the order was received?​

Correct AnswerverifiedShow Answer

Which of the following is NOT a comparison operator?

Correct Answer
verified

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 published in 2001?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders that were not shipped for at least three days after the order was received?

Correct Answer
verified