Question 1

The percent sign (%)and asterisk (*)symbols can be used with the LIKE comparison operator to create a search pattern.

Accepted Answer

A) True 
 B)False  False

Question 2

A NULL value is the same as a blank space.​

Accepted Answer

A) True 
 B)False  False

Question 3

Logical operators are evaluated in the order of NOT,AND,and OR.​

Accepted Answer

A) True 
 B)False  True

Question 4

Contents of BOOKS table
   ​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return the category and title of all books stored in the BOOKS table presented in order of their category and,for the books in the same category,sort the title of the books in descending order?

Accepted Answer

A)  ​SELECT category,title FROM books
ORDERED BY 1,2 DESC; 
B)  ​SELECT category,title FROM books
ORDER BY 1 ASC,2 DESC; 
C)  ​SELECT category,title FROM books
SORTED BY 1 ASC,2 DESC; 
D)  ​SELECT category,title FROM books
SORT BY 1,2 DESC; 
A)  ​SELECT category,title FROM books
ORDERED BY 1,2 DESC; 
B)  ​SELECT category,title FROM books
ORDER BY 1 ASC,2 DESC; 
C)  ​SELECT category,title FROM books
SORTED BY 1 ASC,2 DESC; 
D)  ​SELECT category,title FROM books
SORT BY 1,2 DESC;

Question 5

The numeric order of columns in a SELECT clause can be referenced in the ORDER BY clause._________________________​

Accepted Answer

A) True 
 B)False

Question 6

When two conditions are joined by the AND logical operator,both of the conditions must be evaluated as TRUE to be included in the query results.​

Accepted Answer

A) True 
 B)False

Question 7

The ,!=,or ^= operators can be used to search for values that are not equivalent to the specified search condition._________________________​

Accepted Answer

A) True 
 B)False

Question 8

The order in which NULL values appear in the results can be overridden by which of the following keywords?​

Accepted Answer

A)  ​NULLS FIRST 
B)  ​NULLS LAST 
C)  ​NSEQ 
D)  ​both a and b 
A)  ​NULLS FIRST 
B)  ​NULLS LAST 
C)  ​NSEQ 
D)  ​both a and b

Question 9

Contents of the ORDERS table
  
-​Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will return all orders shipped within 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; D) SELECT * FROM orders WHERE shipdate-orderdate <= 3; A) SELECT * FROM orders WHERE shipdate-orderdate >= 3; B) SELECT * FROM orders WHERE shipdate-orderdate = 3; D) SELECT * FROM orders WHERE shipdate-orderdate <= 3;

Question 10

A(n)____________________ sort can be specified in the ORDER BY clause to indicate that if an exact match occurs during the primary sort,the alternate column listed should be used to determine the presentation sequence.​

Accepted Answer

The answer of A(n)____________________ sort can be specified in the...

Question 11

NOT,ALL,and OR are all considered logical operators.​

Accepted Answer

A) True 
 B)False

Question 12

When two conditions are joined by the AND logical operator,only one of the conditions must be TRUE to be included in the query results.​

Accepted Answer

A) True 
 B)False

Question 13

The ____________________ logical operator is similar to the IN comparison operator.​

Accepted Answer

The answer of The ____________________ logical operator is similar to...

Question 14

A search condition can be specified in a(n)SELECT clause._________________________​

Accepted Answer

A) True 
 B)False

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 
A)  ​ColB IS NOT NULL 
B)  ​ColB ^= NULL 
C)  ​ColB != NULL 
D)  ​all of the above

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The underscore symbol (_)is used in a search pattern to indicate "exactly one character in this position".​

Accepted Answer

A) True 
 B)False

Question 18

​To find rows containing a NULL value in a specified column,you must use the search condition of = NULL.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following clauses is used to restrict the rows returned by a query?​

Accepted Answer

A)  ​SELECT 
B)  ​FROM 
C)  ​WHERE 
D)  ​ORDER BY 
A)  ​SELECT 
B)  ​FROM 
C)  ​WHERE 
D)  ​ORDER BY

Question 20

If a user performs a query that restricts the rows returned based upon a specified date,the date must be enclosed in ____.​

Accepted Answer

A)  ​double quotation marks (" ") 
B)  ​single quotation marks (' ') 
C)  ​parentheses ( ) 
D)  ​none of the above 
A)  ​double quotation marks (" ") 
B)  ​single quotation marks (' ') 
C)  ​parentheses ( ) 
D)  ​none of the above

The percent sign (%)and asterisk (*)symbols can be used with the LIKE comparison operator to create a search pattern.

A NULL value is the same as a blank space.

Logical operators are evaluated in the order of NOT,AND,and OR.

The numeric order of columns in a SELECT clause can be referenced in the ORDER BY clause._________________________

When two conditions are joined by the AND logical operator,both of the conditions must be evaluated as TRUE to be included in the query results.

The <>,!=,or ^= operators can be used to search for values that are not equivalent to the specified search condition._________________________

The order in which NULL values appear in the results can be overridden by which of the following keywords?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will return all orders shipped within three days after the order was received?

A(n)____________________ sort can be specified in the ORDER BY clause to indicate that if an exact match occurs during the primary sort,the alternate column listed should be used to determine the presentation sequence.

NOT,ALL,and OR are all considered logical operators.

When two conditions are joined by the AND logical operator,only one of the conditions must be TRUE to be included in the query results.

The ____________________ logical operator is similar to the IN comparison operator.

A search condition can be specified in a(n)SELECT clause._________________________

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

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

The underscore symbol (_)is used in a search pattern to indicate "exactly one character in this position".

To find rows containing a NULL value in a specified column,you must use the search condition of = NULL.

Which of the following clauses is used to restrict the rows returned by a query?

If a user performs a query that restricts the rows returned based upon a specified date,the date must be enclosed in ____.

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 percent sign (%)and asterisk (*)symbols can be used with the LIKE comparison operator to create a search pattern.

A NULL value is the same as a blank space.​

Logical operators are evaluated in the order of NOT,AND,and OR.​

The numeric order of columns in a SELECT clause can be referenced in the ORDER BY clause._________________________​

When two conditions are joined by the AND logical operator,both of the conditions must be evaluated as TRUE to be included in the query results.​

The <>,!=,or ^= operators can be used to search for values that are not equivalent to the specified search condition._________________________​

The order in which NULL values appear in the results can be overridden by which of the following keywords?​

Contents of the ORDERS table -​Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will return all orders shipped within three days after the order was received?

A(n)____________________ sort can be specified in the ORDER BY clause to indicate that if an exact match occurs during the primary sort,the alternate column listed should be used to determine the presentation sequence.​

NOT,ALL,and OR are all considered logical operators.​

When two conditions are joined by the AND logical operator,only one of the conditions must be TRUE to be included in the query results.​

The ____________________ logical operator is similar to the IN comparison operator.​

A search condition can be specified in a(n)SELECT clause._________________________​

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

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

The underscore symbol (_)is used in a search pattern to indicate "exactly one character in this position".​

​To find rows containing a NULL value in a specified column,you must use the search condition of = NULL.

Which of the following clauses is used to restrict the rows returned by a query?​

If a user performs a query that restricts the rows returned based upon a specified date,the date must be enclosed in ____.​

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

A NULL value is the same as a blank space.

Logical operators are evaluated in the order of NOT,AND,and OR.

The numeric order of columns in a SELECT clause can be referenced in the ORDER BY clause._________________________

When two conditions are joined by the AND logical operator,both of the conditions must be evaluated as TRUE to be included in the query results.

The <>,!=,or ^= operators can be used to search for values that are not equivalent to the specified search condition._________________________

The order in which NULL values appear in the results can be overridden by which of the following keywords?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will return all orders shipped within three days after the order was received?

A(n)____________________ sort can be specified in the ORDER BY clause to indicate that if an exact match occurs during the primary sort,the alternate column listed should be used to determine the presentation sequence.

NOT,ALL,and OR are all considered logical operators.

When two conditions are joined by the AND logical operator,only one of the conditions must be TRUE to be included in the query results.

The ____________________ logical operator is similar to the IN comparison operator.

A search condition can be specified in a(n)SELECT clause._________________________

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

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

The underscore symbol (_)is used in a search pattern to indicate "exactly one character in this position".

To find rows containing a NULL value in a specified column,you must use the search condition of = NULL.

Which of the following clauses is used to restrict the rows returned by a query?

If a user performs a query that restricts the rows returned based upon a specified date,the date must be enclosed in ____.