Question 1

____________________ operators are used to combine search conditions in the WHERE clause of a query.​

Accepted Answer

The answer of ____________________ operators are used to combine search...

Question 2

The ____________________ logical operator is used to combine search conditions when only one of the conditions must be TRUE to be included in the results.​

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

When sorting the results in descending 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 5

The ____________________ logical operator is evaluated first in a sequence of logical operators.​

Accepted Answer

The answer of The ____________________ logical operator is evaluated first...

Question 6

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?​

Accepted Answer

A)  ​SELECT * FROM orders WHERE shipdate = NULL; 
B)  ​SELECT * FROM orders WHERE shipdate > NULL; 
C)  ​SELECT * FROM orders WHERE shipdate LIKE 'NULL'; 
D)  ​none of the above 
A)  ​SELECT * FROM orders WHERE shipdate = NULL; 
B)  ​SELECT * FROM orders WHERE shipdate > NULL; 
C)  ​SELECT * FROM orders WHERE shipdate LIKE 'NULL'; 
D)  ​none of the above

Question 7

The "equal to" comparison operator is used to search for NULL values._________________________​

Accepted Answer

A) True 
 B)False

Question 8

By default,a column listed in an ORDER BY clause is displayed in ____________________ order.​

Accepted Answer

The answer of By default,a column listed in an ORDER...

Question 9

​When the WHERE clause contains multiple types of operators,which of the following is resolved last?

Accepted Answer

A)  ​arithmetic operations 
B)  ​comparison operators 
C)  ​logical operators 
D)  ​search patterns 
A)  ​arithmetic operations 
B)  ​comparison operators 
C)  ​logical operators 
D)  ​search patterns

Question 10

A(n)percent sign is used in a search pattern to indicate zero,one,or more characters in a position._________________________

Accepted Answer

A) True 
 B)False

Question 11

To instruct Oracle12c to sort data in descending order,enter ____ after the column name in the WHERE clause.​

Accepted Answer

A)  ​D 
B)  ​DES 
C)  ​DESC 
D)  ​none of the above 
A)  ​D 
B)  ​DES 
C)  ​DESC 
D)  ​none of the above

Question 12

If a numeric column is being used for comparison against the search condition,the search condition is enclosed in single quotation marks._________________________​

Accepted Answer

A) True 
 B)False

Question 13

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.​

Accepted Answer

The answer of The ____________________ keywords can be included in...

Question 14

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?​

Accepted Answer

A)  ​SELECT * FROM orders WHERE shipdate = 'NOT NULL'; 
B)  ​SELECT * FROM orders WHERE shipdate = NOT NULL; 
C)  ​SELECT * FROM orders WHERE shipdate IS NULL; 
D)  ​SELECT * FROM orders WHERE shipdate IS NOT NULL; 
A)  ​SELECT * FROM orders WHERE shipdate = 'NOT NULL'; 
B)  ​SELECT * FROM orders WHERE shipdate = NOT NULL; 
C)  ​SELECT * FROM orders WHERE shipdate IS NULL; 
D)  ​SELECT * FROM orders WHERE shipdate IS NOT NULL;

Question 15

When sorting data,the values will be sorted in ascending order by default._________________________​

Accepted Answer

A) True 
 B)False

Question 16

​Comparison operators are used to combine search conditions.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $24.00?​

Accepted Answer

A)  ​LIKE 
B)  ​BETWEEN 
C)  ​> 
D)  ​>= 
A)  ​LIKE 
B)  ​BETWEEN 
C)  ​> 
D)  ​>=

Question 18

The percent sign (%)is used in a search pattern to indicate "exactly one character in this position".​

Accepted Answer

A) True 
 B)False

Question 19

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.​

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed first in the results.​

Accepted Answer

The answer of The ____________________ keywords can be included in...

____________________ operators are used to combine search conditions in the WHERE clause of a query.

The ____________________ logical operator is used to combine search conditions when only one of the conditions must be TRUE to be included in the results.

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

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

The ____________________ logical operator is evaluated first in a sequence of logical operators.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?

The "equal to" comparison operator is used to search for NULL values._________________________

By default,a column listed in an ORDER BY clause is displayed in ____________________ order.

When the WHERE clause contains multiple types of operators,which of the following is resolved last?

A(n)percent sign is used in a search pattern to indicate zero,one,or more characters in a position._________________________

To instruct Oracle12c to sort data in descending order,enter ____ after the column name in the WHERE clause.

If a numeric column is being used for comparison against the search condition,the search condition is enclosed in single quotation marks._________________________

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?

When sorting data,the values will be sorted in ascending order by default._________________________

Comparison operators are used to combine search conditions.

Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $24.00?

The percent sign (%)is used in a search pattern to indicate "exactly one character in this position".

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed first in the results.

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

____________________ operators are used to combine search conditions in the WHERE clause of a query.​

The ____________________ logical operator is used to combine search conditions when only one of the conditions must be TRUE to be included in the results.​

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

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

The ____________________ logical operator is evaluated first in a sequence of logical operators.​

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?​

The "equal to" comparison operator is used to search for NULL values._________________________​

By default,a column listed in an ORDER BY clause is displayed in ____________________ order.​

​When the WHERE clause contains multiple types of operators,which of the following is resolved last?

A(n)percent sign is used in a search pattern to indicate zero,one,or more characters in a position._________________________

To instruct Oracle12c to sort data in descending order,enter ____ after the column name in the WHERE clause.​

If a numeric column is being used for comparison against the search condition,the search condition is enclosed in single quotation marks._________________________​

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.​

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?​

When sorting data,the values will be sorted in ascending order by default._________________________​

​Comparison operators are used to combine search conditions.

Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $24.00?​

The percent sign (%)is used in a search pattern to indicate "exactly one character in this position".​

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.​

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed first in the results.​

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

____________________ operators are used to combine search conditions in the WHERE clause of a query.

The ____________________ logical operator is used to combine search conditions when only one of the conditions must be TRUE to be included in the results.

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

The ____________________ logical operator is evaluated first in a sequence of logical operators.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?

The "equal to" comparison operator is used to search for NULL values._________________________

By default,a column listed in an ORDER BY clause is displayed in ____________________ order.

When the WHERE clause contains multiple types of operators,which of the following is resolved last?

To instruct Oracle12c to sort data in descending order,enter ____ after the column name in the WHERE clause.

If a numeric column is being used for comparison against the search condition,the search condition is enclosed in single quotation marks._________________________

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?

When sorting data,the values will be sorted in ascending order by default._________________________

Comparison operators are used to combine search conditions.

Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $24.00?

The percent sign (%)is used in a search pattern to indicate "exactly one character in this position".

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed first in the results.