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 BETWEEN operator is used to determine the rows that match a value in a given list._________________________​

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

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?​

Accepted Answer

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

Question 5

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?​

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; 
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 6

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 7

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 8

Which of the following is NOT a comparison operator?​

Accepted Answer

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

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

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

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

The ____________________ symbol is used for determining whether or not a value is greater 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 retrieve all books published in 2001?

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?

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

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

Which of the following is NOT a comparison operator?

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

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

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

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

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 data is sorted in ascending order,NULL values appear first in the list._________________________​

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

The ____________________ symbol is used for determining whether or not a value is greater 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 retrieve all books published in 2001?​

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?​

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

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

Which of the following is NOT a comparison operator?​

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

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

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

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

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

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

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

The ____________________ symbol is used for determining whether or not a value is greater 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 retrieve all books published in 2001?

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?

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

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

Which of the following is NOT a comparison operator?

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

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

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

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