Exam 10: Selected Single-Row Functions

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following SQL statements will display the number of days between the date an order was placed and the date it was shipped?

(Multiple Choice)

4.7/5

(45)

Question 41

The ____________________ function converts character strings to mixed-case,with each word beginning with a capital letter.

(Short Answer)

4.8/5

(23)

Question 42

Which of the following is used to return a portion of a character string?

(Multiple Choice)

4.9/5

(33)

Question 43

Character functions can be used to change the case of characters or to manipulate characters.

(True/False)

4.7/5

(34)

Question 44

Which of the following functions is used to determine the number of months between two date values?

(Multiple Choice)

4.8/5

(35)

Question 45

Single-row functions return one row of results for each group or category of rows processed.

(True/False)

4.8/5

(41)

Question 46

To add a series of asterisks (*)to a column with the intent of extending it to a specific length,you can use the LPAD or RPAD function._________________________

(True/False)

4.9/5

(32)

Question 47

Which of the following format elements will display 1:00 p.m.as 13?

(Multiple Choice)

4.7/5

(38)

Question 48

The INITIALCAP function can be used to convert character strings to mixed-case characters.

(True/False)

4.8/5

(37)

Question 49

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Which of the following SQL statements will return an error message,based upon the contents of the CUSTOMERS table?

(Multiple Choice)

4.8/5

(29)

Question 50

The CONCAT function can be used to concatenate the data contained in two columns._________________________

(True/False)

4.7/5

(25)

Question 51

SYSTEMDATE can be used to include the computer's date in a SQL statement._________________________

(True/False)

4.7/5

(32)

Question 52

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

(Multiple Choice)

4.9/5

(39)

Question 53

A(n)____________________ number is used in the ROUND function to indicate that the data should be rounded to a position on the left side of the decimal point.

(Short Answer)

4.8/5

(35)

Question 54

Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

(Multiple Choice)

4.9/5

(30)

Question 55

The REPLACE function is used to substitute one character string for another character string in a set of data.

(True/False)

4.8/5

(34)

Question 56

The SUBSTR function is used to return a portion of a character string._________________________

(True/False)

4.7/5

(43)

Question 57

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following will display the shipping location as: Shipcity,Shipstate Shipzip

(Multiple Choice)

4.9/5

(36)

Question 58

Which of the following format argument elements will display the number of seconds past midnight?

(Multiple Choice)

4.9/5

(31)

Question 59

The ____________________ function can be used to determine the number of characters in a string.

(Short Answer)

4.8/5

(34)

Question 60

Showing 41 - 60 of 133

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following SQL statements will display the number of days between the date an order was placed and the date it was shipped?

The ____________________ function converts character strings to mixed-case,with each word beginning with a capital letter.

Which of the following is used to return a portion of a character string?

Character functions can be used to change the case of characters or to manipulate characters.

Which of the following functions is used to determine the number of months between two date values?

Single-row functions return one row of results for each group or category of rows processed.

To add a series of asterisks (*)to a column with the intent of extending it to a specific length,you can use the LPAD or RPAD function._________________________

Which of the following format elements will display 1:00 p.m.as 13?

The INITIALCAP function can be used to convert character strings to mixed-case characters.

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Which of the following SQL statements will return an error message,based upon the contents of the CUSTOMERS table?

The CONCAT function can be used to concatenate the data contained in two columns._________________________

SYSTEMDATE can be used to include the computer's date in a SQL statement._________________________

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

A(n)____________________ number is used in the ROUND function to indicate that the data should be rounded to a position on the left side of the decimal point.

Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

The REPLACE function is used to substitute one character string for another character string in a set of data.

The SUBSTR function is used to return a portion of a character string._________________________

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following will display the shipping location as: Shipcity,Shipstate Shipzip

Which of the following format argument elements will display the number of seconds past midnight?

The ____________________ function can be used to determine the number of characters in a string.

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

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 10: Selected Single-Row Functions

​Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -​Based upon the contents of the ORDERS table,which of the following SQL statements will display the number of days between the date an order was placed and the date it was shipped?

The ____________________ function converts character strings to mixed-case,with each word beginning with a capital letter.​

Which of the following is used to return a portion of a character string?​

​Character functions can be used to change the case of characters or to manipulate characters.

​Which of the following functions is used to determine the number of months between two date values?

Single-row functions return one row of results for each group or category of rows processed.​

To add a series of asterisks (*)to a column with the intent of extending it to a specific length,you can use the LPAD or RPAD function._________________________​

​Which of the following format elements will display 1:00 p.m.as 13?

The INITIALCAP function can be used to convert character strings to mixed-case characters.​

Contents of the CUSTOMERS table ​ Note: The ST column name is truncated,this represents the STATE column. -Which of the following SQL statements will return an error message,based upon the contents of the CUSTOMERS table?​

The CONCAT function can be used to concatenate the data contained in two columns._________________________​

SYSTEMDATE can be used to include the computer's date in a SQL statement._________________________​

​Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -​Based upon the contents of the ORDERS table,which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

A(n)____________________ number is used in the ROUND function to indicate that the data should be rounded to a position on the left side of the decimal point.​

​Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

The REPLACE function is used to substitute one character string for another character string in a set of data.

The SUBSTR function is used to return a portion of a character string._________________________​

​Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following will display the shipping location as: Shipcity,Shipstate Shipzip​

​Which of the following format argument elements will display the number of seconds past midnight?

The ____________________ function can be used to determine the number of characters in a string.​

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

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Group Functions

Subqueries and Merge Statements

Views

Filters

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following SQL statements will display the number of days between the date an order was placed and the date it was shipped?

The ____________________ function converts character strings to mixed-case,with each word beginning with a capital letter.

Which of the following is used to return a portion of a character string?

Character functions can be used to change the case of characters or to manipulate characters.

Which of the following functions is used to determine the number of months between two date values?

Single-row functions return one row of results for each group or category of rows processed.

To add a series of asterisks (*)to a column with the intent of extending it to a specific length,you can use the LPAD or RPAD function._________________________

Which of the following format elements will display 1:00 p.m.as 13?

The INITIALCAP function can be used to convert character strings to mixed-case characters.

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Which of the following SQL statements will return an error message,based upon the contents of the CUSTOMERS table?

The CONCAT function can be used to concatenate the data contained in two columns._________________________

SYSTEMDATE can be used to include the computer's date in a SQL statement._________________________

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

A(n)____________________ number is used in the ROUND function to indicate that the data should be rounded to a position on the left side of the decimal point.

Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

The SUBSTR function is used to return a portion of a character string._________________________

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table,which of the following will display the shipping location as: Shipcity,Shipstate Shipzip

Which of the following format argument elements will display the number of seconds past midnight?

The ____________________ function can be used to determine the number of characters in a string.