Question 1

The ____________________ clause is used to specify the order in which the data should be presented in the results of a query.

Accepted Answer

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

Question 2

The  symbol is used to search for records containing a value that is less than or equal to the stated search condition._________________________​

Accepted Answer

A) True 
 B)False

Question 3

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 4

The LIKE operator is used to indicate a range of values._________________________​

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

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table.​

Accepted Answer

A) True 
 B)False

Question 7

In a WHERE clause,logical operators are evaluated before comparison operators.​

Accepted Answer

A) True 
 B)False

Question 8

____________________ is the process by which only certain rows are returned in the results of a query.​

Accepted Answer

The answer of ____________________ is the process by which only...

Question 9

Contents of BOOKS table
   ​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

Accepted Answer

A)  ​SELECT title FROM books
WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35; 
B)  ​SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35; 
C)  ​SELECT title FROM books
WHERE (category = 'BUSINESS' OR category ='COMPUTER' )AND retail >35; 
D)  ​SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35); 
A)  ​SELECT title FROM books
WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35; 
B)  ​SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35; 
C)  ​SELECT title FROM books
WHERE (category = 'BUSINESS' OR category ='COMPUTER' )AND retail >35; 
D)  ​SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35);

Question 10

A(n)clause identifies what must exist or a requirement that must be met for a record to be included in the results of a query._________________________​

Accepted Answer

A) True 
 B)False

Question 11

Retrieving only certain rows from a table is known as projection.​

Accepted Answer

A) True 
 B)False

Question 12

The IN logical operator is similar to using OR._________________________​

Accepted Answer

A) True 
 B)False

Question 13

To indicate that data should be sorted in descending order,use the DESC keyword._________________________​

Accepted Answer

A) True 
 B)False

Question 14

​Which of the following is not a valid comparison operator?

Accepted Answer

A)  ​=> 
B)  ​ 
C)  ​^= 
D)  ​none of the above 
A)  ​=> 
B)  ​ 
C)  ​^= 
D)  ​none of the above

Question 15

What is the purpose of the ORDER BY clause?​

Accepted Answer

The ORDER BY clause is used to

Question 16

Which of the following is a valid comparison operator?​

Accepted Answer

A)  ​!= 
B)  ​IN 
C)  ​^= 
D)  ​all of the above 
A)  ​!= 
B)  ​IN 
C)  ​^= 
D)  ​all of the above

Question 17

When two conditions are joined by the AND keyword,both conditions must be FALSE  for a record to be included in the results._________________________​

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

A(n)____ is used to indicate how data should relate to a given search condition.​

Accepted Answer

A)  ​comparison operator 
B)  ​logical operator 
C)  ​search pattern 
D)  ​criteria 
A)  ​comparison operator 
B)  ​logical operator 
C)  ​search pattern 
D)  ​criteria

The ____________________ clause is used to specify the order in which the data should be presented in the results of a query.

The < symbol is used to search for records containing a value that is less than or equal to the stated search condition._________________________

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.

The LIKE operator is used to indicate a range of values._________________________

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?

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table.

In a WHERE clause,logical operators are evaluated before comparison operators.

____________________ is the process by which only certain rows are returned in the results of a query.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

A(n)clause identifies what must exist or a requirement that must be met for a record to be included in the results of a query._________________________

Retrieving only certain rows from a table is known as projection.

The IN logical operator is similar to using OR._________________________

To indicate that data should be sorted in descending order,use the DESC keyword._________________________

Which of the following is not a valid comparison operator?

What is the purpose of the ORDER BY clause?

Which of the following is a valid comparison operator?

When two conditions are joined by the AND keyword,both conditions must be FALSE for a record to be included in the results._________________________

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

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

A(n)____ is used to indicate how data should relate to a given search condition.

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 ____________________ clause is used to specify the order in which the data should be presented in the results of a query.

The < symbol is used to search for records containing a value that is less than or equal to the stated search condition._________________________​

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.

The LIKE operator is used to indicate a range of values._________________________​

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

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table.​

In a WHERE clause,logical operators are evaluated before comparison operators.​

____________________ is the process by which only certain rows are returned in the results of a query.​

Contents of BOOKS table ​ -​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

A(n)clause identifies what must exist or a requirement that must be met for a record to be included in the results of a query._________________________​

Retrieving only certain rows from a table is known as projection.​

The IN logical operator is similar to using OR._________________________​

To indicate that data should be sorted in descending order,use the DESC keyword._________________________​

​Which of the following is not a valid comparison operator?

What is the purpose of the ORDER BY clause?​

Which of the following is a valid comparison operator?​

When two conditions are joined by the AND keyword,both conditions must be FALSE for a record to be included in the results._________________________​

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

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

A(n)____ is used to indicate how data should relate to a given search condition.​

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 < symbol is used to search for records containing a value that is less than or equal to the stated search condition._________________________

The LIKE operator is used to indicate a range of values._________________________

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?

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table.

In a WHERE clause,logical operators are evaluated before comparison operators.

____________________ is the process by which only certain rows are returned in the results of a query.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

A(n)clause identifies what must exist or a requirement that must be met for a record to be included in the results of a query._________________________

Retrieving only certain rows from a table is known as projection.

The IN logical operator is similar to using OR._________________________

To indicate that data should be sorted in descending order,use the DESC keyword._________________________

Which of the following is not a valid comparison operator?

What is the purpose of the ORDER BY clause?

Which of the following is a valid comparison operator?

When two conditions are joined by the AND keyword,both conditions must be FALSE for a record to be included in the results._________________________

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

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

A(n)____ is used to indicate how data should relate to a given search condition.