Question 1

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 2

Contents of the ORDERS table
  
-Which of the following queries will display all orders placed in the month of March?​

Accepted Answer

A)  ​SELECT * FROM orders WHERE orderdate LIKE '%Mar%'; 
B)  ​SELECT * FROM orders WHERE orderdate LIKE '_Mar_'; 
C)  ​SELECT * FROM orders WHERE orderdate LIKE "%Mar%"; 
D)  ​none of the above 
A)  ​SELECT * FROM orders WHERE orderdate LIKE '%Mar%'; 
B)  ​SELECT * FROM orders WHERE orderdate LIKE '_Mar_'; 
C)  ​SELECT * FROM orders WHERE orderdate LIKE "%Mar%"; 
D)  ​none of the above

Question 3

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 4

A(n)____________________ identifies what must exist or a requirement that must be met before a row is included in the results of a query.​

Accepted Answer

The answer of A(n)____________________ identifies what must exist or a...

Question 5

Search conditions for data contained in numeric columns must be enclosed in single quotation marks.

Accepted Answer

A) True 
 B)False

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

The ____________________ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.​

Accepted Answer

BETWEEN
BE

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

Contents of BOOKS table
   ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will display the title and retail price of each book stored in the BOOKS table in order of category and retail price?​

Accepted Answer

A)  ​SELECT title,retail FROM books
ORDER BY category,retail; 
B)  ​SELECT title,retail FROM books
ORDERED BY category,retail; 
C)  ​SELECT title,retail FROM books
SORT BY category,retail; 
D)  ​none of the above 
A)  ​SELECT title,retail FROM books
ORDER BY category,retail; 
B)  ​SELECT title,retail FROM books
ORDERED BY category,retail; 
C)  ​SELECT title,retail FROM books
SORT BY category,retail; 
D)  ​none of the above

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)____________________ column,the...

Question 12

The ____________________ clause is used to restrict the rows returned by a query.​

Accepted Answer

The answer of The ____________________ clause is used to restrict...

Question 13

Contents of BOOKS table
   ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list the title and retail price of each book stored in the BOOKS table,sorted in order of the book titles?​

Accepted Answer

A)  ​SELECT title,retail FROM books
ORDERED BY title; 
B)  ​SELECT title,retail FROM books
SORTED BY title; 
C)  ​SELECT title,retail FROM books
ORDER BY title; 
D)  ​SELECT title,retail FROM books
SORT BY title; 
A)  ​SELECT title,retail FROM books
ORDERED BY title; 
B)  ​SELECT title,retail FROM books
SORTED BY title; 
C)  ​SELECT title,retail FROM books
ORDER BY title; 
D)  ​SELECT title,retail FROM books
SORT BY title;

Question 14

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 shipped between April 4,2003 and April 5,2003?​

Accepted Answer

A) SELECT * FROM orders WHERE shipdate = '05-APR-03'; B) SELECT * FROM orders WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03'; C) SELECT * FROM orders WHERE shipdate >= '04-APR-03' AND shipdate <= '05-APR-03'; D) both b and c A) SELECT * FROM orders WHERE shipdate = '05-APR-03'; B) SELECT * FROM orders WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03'; C) SELECT * FROM orders WHERE shipdate >= '04-APR-03' AND shipdate <= '05-APR-03'; D) both b and c

Question 15

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 16

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?​

Accepted Answer

A)  ​SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDER BY customer#,order#; 
B)  ​SELECT * FROM orders
WHERE shipdate IS NULL
ORDER BY customer#,order#; 
C)  ​SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDERED BY customer#,order#; 
D)  ​SELECT * FROM orders
WHERE shipdate IS NOT NULL
SORTED BY customer#,order#; 
A)  ​SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDER BY customer#,order#; 
B)  ​SELECT * FROM orders
WHERE shipdate IS NULL
ORDER BY customer#,order#; 
C)  ​SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDERED BY customer#,order#; 
D)  ​SELECT * FROM orders
WHERE shipdate IS NOT NULL
SORTED BY customer#,order#;

Question 17

The SORT BY clause is used to present query results in a specific order.​

Accepted Answer

A) True 
 B)False

Question 18

Using the OR logical operator to combine search conditions based upon the same column is the same as using the IN comparison operator.​

Accepted Answer

A) True 
 B)False

Question 19

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 20

Which of the following operators can be used to retrieve rows containing NULL values in a specific column?​

Accepted Answer

A)  ​= 
B)  ​LIKE 
C)  ​NOT 
D)  ​none of the above 
A)  ​= 
B)  ​LIKE 
C)  ​NOT 
D)  ​none of the above

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

Contents of the ORDERS table -Which of the following queries will display all orders placed in the month of March?

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

A(n)____________________ identifies what must exist or a requirement that must be met before a row is included in the results of a query.

Search conditions for data contained in numeric columns must be enclosed in single quotation marks.

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

The ____________________ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.

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

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will display the title and retail price of each book stored in the BOOKS table in order of category and retail price?

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

The ____________________ clause is used to restrict the rows returned by a query.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list the title and retail price of each book stored in the BOOKS table,sorted in order of the book titles?

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 shipped between April 4,2003 and April 5,2003?

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?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?

The SORT BY clause is used to present query results in a specific order.

Using the OR logical operator to combine search conditions based upon the same column is the same as using the IN comparison operator.

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.

Which of the following operators can be used to retrieve rows containing NULL values in a specific column?

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 ____________________ comparison operator is used when the search condition includes a search pattern.​

Contents of the ORDERS table -Which of the following queries will display all orders placed in the month of March?​

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

A(n)____________________ identifies what must exist or a requirement that must be met before a row is included in the results of a query.​

Search conditions for data contained in numeric columns must be enclosed in single quotation marks.

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

The ____________________ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.​

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

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

Contents of BOOKS table ​ -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will display the title and retail price of each book stored in the BOOKS table in order of category and retail price?​

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

The ____________________ clause is used to restrict the rows returned by a query.​

Contents of BOOKS table ​ -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list the title and retail price of each book stored in the BOOKS table,sorted in order of the book titles?​

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 shipped between April 4,2003 and April 5,2003?​

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

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?​

The SORT BY clause is used to present query results in a specific order.​

Using the OR logical operator to combine search conditions based upon the same column is the same as using the IN comparison operator.​

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

Which of the following operators can be used to retrieve rows containing NULL values in a specific column?​

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 ____________________ comparison operator is used when the search condition includes a search pattern.

Contents of the ORDERS table -Which of the following queries will display all orders placed in the month of March?

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

A(n)____________________ identifies what must exist or a requirement that must be met before a row is included in the results of a query.

The ____________________ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.

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

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will display the title and retail price of each book stored in the BOOKS table in order of category and retail price?

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

The ____________________ clause is used to restrict the rows returned by a query.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list the title and retail price of each book stored in the BOOKS table,sorted in order of the book titles?

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 shipped between April 4,2003 and April 5,2003?

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?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?

The SORT BY clause is used to present query results in a specific order.

Using the OR logical operator to combine search conditions based upon the same column is the same as using the IN comparison operator.

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.

Which of the following operators can be used to retrieve rows containing NULL values in a specific column?