Exam 10: Selected Single Row Functions

Including $\underline {\text { MONTH } }$ in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date. _________________________

(True/False)

4.8/5

(37)

Question 61

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.9/5

(46)

Question 62

The MONTHS_BETWEEN function can be used to determine the number of months between two dates.

(True/False)

4.9/5

(31)

Question 63

Which of the following functions can be used to convert a character string to upper-case letters?

(Multiple Choice)

4.9/5

(28)

Question 64

The ADD_MONTHS function is used to add one month to a specified date.

(True/False)

4.9/5

(35)

Question 65

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

(Multiple Choice)

4.9/5

(32)

Question 66

The ____________________ function is used to determine a new date by adding a specified number of months to a date value.

(Short Answer)

4.9/5

(33)

Question 67

Which of the following functions is similar to using the (| |) symbol to combine the contents of two character strings?

(Multiple Choice)

4.8/5

(40)

Question 68

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.9/5

(36)

Question 69

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

(Multiple Choice)

4.8/5

(33)

Question 70

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 ship date for order 1006 as April 2, 2002?

(Multiple Choice)

4.7/5

(34)

Question 71

The table called DUMMY consists of a blank holding area that can be referenced by a user.

(True/False)

4.7/5

(25)

Question 72

Which of the following functions can be used to convert a character string to lower-case letters?

(Multiple Choice)

4.9/5

(32)

Question 73

Which of the following can be used to replace a specific set of characters with another set of characters?

(Multiple Choice)

4.8/5

(36)

Question 74

The $\underline {\text { TO CHAR } }$ function can be used to display insignificant zeros. _________________________

(True/False)

4.8/5

(28)

Question 75

To indicate that the numeric value of the day of the year for a date is being specified, include DAY in format argument of the TO_DATE function.

(True/False)

4.8/5

(28)

Question 76

Describe the order in which Oracle11g resolves nested functions.

(Essay)

4.8/5

(32)

Question 77

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.

(True/False)

4.9/5

(31)

Question 78

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

(True/False)

4.7/5

(39)

Question 79

The $\underline {\text { ROUND } }$ function can be used to truncate numeric data. _________________________

(True/False)

4.9/5

(28)

Question 80

Showing 61 - 80 of 133

Including $\underline {\text { MONTH } }$ in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date. _________________________

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 MONTHS_BETWEEN function can be used to determine the number of months between two dates.

Which of the following functions can be used to convert a character string to upper-case letters?

The ADD_MONTHS function is used to add one month to a specified date.

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

The ____________________ function is used to determine a new date by adding a specified number of months to a date value.

Which of the following functions is similar to using the (| |) symbol to combine the contents of two character strings?

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 argument elements will display the number of seconds past midnight?

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 ship date for order 1006 as April 2, 2002?

The table called DUMMY consists of a blank holding area that can be referenced by a user.

Which of the following functions can be used to convert a character string to lower-case letters?

Which of the following can be used to replace a specific set of characters with another set of characters?

The $\underline {\text { TO CHAR } }$ function can be used to display insignificant zeros. _________________________

To indicate that the numeric value of the day of the year for a date is being specified, include DAY in format argument of the TO_DATE function.

Describe the order in which Oracle11g resolves nested functions.

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.

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

The $\underline {\text { ROUND } }$ function can be used to truncate numeric data. _________________________

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

Including MONTH ‾\underline {\text { MONTH } } MONTH ​ in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date. _________________________

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 MONTHS_BETWEEN function can be used to determine the number of months between two dates.

Which of the following functions can be used to convert a character string to upper-case letters?

The ADD_MONTHS function is used to add one month to a specified date.

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

The ____________________ function is used to determine a new date by adding a specified number of months to a date value.

Which of the following functions is similar to using the (| |) symbol to combine the contents of two character strings?

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 argument elements will display the number of seconds past midnight?

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 ship date for order 1006 as April 2, 2002?

The table called DUMMY consists of a blank holding area that can be referenced by a user.

Which of the following functions can be used to convert a character string to lower-case letters?

Which of the following can be used to replace a specific set of characters with another set of characters?

The TO CHAR ‾\underline {\text { TO CHAR } } TO CHAR ​ function can be used to display insignificant zeros. _________________________

To indicate that the numeric value of the day of the year for a date is being specified, include DAY in format argument of the TO_DATE function.

Describe the order in which Oracle11g resolves nested functions.

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.

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 ‾\underline {\text { LPAD or RPAD }} LPAD or RPAD ​ function. _________________________

The ROUND ‾\underline {\text { ROUND } } ROUND ​ function can be used to truncate numeric data. _________________________

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

Including $\underline {\text { MONTH } }$ in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date. _________________________

The $\underline {\text { TO CHAR } }$ function can be used to display insignificant zeros. _________________________

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

The $\underline {\text { ROUND } }$ function can be used to truncate numeric data. _________________________