Question 1

The ____________________ function is used to round numeric fields to a stated position.​

Accepted Answer

The answer of The ____________________ function is used to round...

Question 2

​Any of the single-row functions covered in this chapter can be used with the DUAL table._________________________

Accepted Answer

A) True 
 B)False

Question 3

Explain the difference between the TO_CHAR and TO_DATE functions when used with date values.​

Accepted Answer

When used with date values,the TO_CHAR f

Question 4

To calculate the difference between two date columns,you must use the TO_DATE function.

Accepted Answer

A) True 
 B)False

Question 5

INITCAP can be used to convert character strings to mixed-case characters._________________________​

Accepted Answer

A) True 
 B)False

Question 6

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.​

Accepted Answer

A) True 
 B)False

Question 7

The ____________________ function is used to convert dates and numbers to a formatted character string.​

Accepted Answer

The answer of The ____________________ function is used to convert...

Question 8

When functions are nested,the outer function is solved or executed first.​

Accepted Answer

A) True 
 B)False

Question 9

The NEXT_DATE function is used to determine the next occurrence of a specific day of the week after a given date._________________________​

Accepted Answer

A) True 
 B)False

Question 10

The ____________________ function allows different actions to be performed based upon whether a NULL value exists in a specified column.​

Accepted Answer

The answer of The ____________________ function allows different actions to...

Question 11

Only a DATE function can be nested inside another DATE function.​

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  ​SUBSTR 
B)  ​REPLACE 
C)  ​FNDRPLCE 
D)  ​none of the above 
A)  ​SUBSTR 
B)  ​REPLACE 
C)  ​FNDRPLCE 
D)  ​none of the above

Question 13

The LENGTH function is used to determine the number of rows in a table.​

Accepted Answer

A) True 
 B)False

Question 14

To indicate that the three-letter abbreviation for day of the week should be displayed,include ____________________ in the date element format argument.​

Accepted Answer

The answer of To indicate that the three-letter abbreviation for...

Question 15

When functions are nested,the inner function is solved first._________________________

Accepted Answer

A) True 
 B)False

Question 16

A single-row function can be used with the DUAL table.​

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ function fills the area to the right of a character string with a specific character.​

Accepted Answer

The answer of The ____________________ function fills the area to...

Question 18

The TO CHAR function can be used to display insignificant zeros._________________________​

Accepted Answer

A) True 
 B)False

Question 19

​Which of the following functions will truncate a numeric value to a specific position?

Accepted Answer

A)  ​TRUNCATE 
B)  ​TRUNC 
C)  ​TRUND 
D)  ​none of the above 
A)  ​TRUNCATE 
B)  ​TRUNC 
C)  ​TRUND 
D)  ​none of the above

Question 20

​Which of the following functions can be used to fill a character string to a specific width?

Accepted Answer

A)  ​LPAD 
B)  ​RPAD 
C)  ​LFILL 
D)  ​both a and b 
A)  ​LPAD 
B)  ​RPAD 
C)  ​LFILL 
D)  ​both a and b

The ____________________ function is used to round numeric fields to a stated position.

Any of the single-row functions covered in this chapter can be used with the DUAL table._________________________

Explain the difference between the TO_CHAR and TO_DATE functions when used with date values.

To calculate the difference between two date columns,you must use the TO_DATE function.

INITCAP can be used to convert character strings to mixed-case characters._________________________

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.

The ____________________ function is used to convert dates and numbers to a formatted character string.

When functions are nested,the outer function is solved or executed first.

The NEXT_DATE function is used to determine the next occurrence of a specific day of the week after a given date._________________________

The ____________________ function allows different actions to be performed based upon whether a NULL value exists in a specified column.

Only a DATE function can be nested inside another DATE function.

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

The LENGTH function is used to determine the number of rows in a table.

To indicate that the three-letter abbreviation for day of the week should be displayed,include ____________________ in the date element format argument.

When functions are nested,the inner function is solved first._________________________

A single-row function can be used with the DUAL table.

The ____________________ function fills the area to the right of a character string with a specific character.

The TO CHAR function can be used to display insignificant zeros._________________________

Which of the following functions will truncate a numeric value to a specific position?

Which of the following functions can be used to fill a character string to a specific width?

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

The ____________________ function is used to round numeric fields to a stated position.​

​Any of the single-row functions covered in this chapter can be used with the DUAL table._________________________

Explain the difference between the TO_CHAR and TO_DATE functions when used with date values.​

To calculate the difference between two date columns,you must use the TO_DATE function.

INITCAP can be used to convert character strings to mixed-case characters._________________________​

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.​

The ____________________ function is used to convert dates and numbers to a formatted character string.​

When functions are nested,the outer function is solved or executed first.​

The NEXT_DATE function is used to determine the next occurrence of a specific day of the week after a given date._________________________​

The ____________________ function allows different actions to be performed based upon whether a NULL value exists in a specified column.​

Only a DATE function can be nested inside another DATE function.​

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

The LENGTH function is used to determine the number of rows in a table.​

To indicate that the three-letter abbreviation for day of the week should be displayed,include ____________________ in the date element format argument.​

When functions are nested,the inner function is solved first._________________________

A single-row function can be used with the DUAL table.​

The ____________________ function fills the area to the right of a character string with a specific character.​

The TO CHAR function can be used to display insignificant zeros._________________________​

​Which of the following functions will truncate a numeric value to a specific position?

​Which of the following functions can be used to fill a character string to a specific width?

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

The ____________________ function is used to round numeric fields to a stated position.

Any of the single-row functions covered in this chapter can be used with the DUAL table._________________________

Explain the difference between the TO_CHAR and TO_DATE functions when used with date values.

INITCAP can be used to convert character strings to mixed-case characters._________________________

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.

The ____________________ function is used to convert dates and numbers to a formatted character string.

When functions are nested,the outer function is solved or executed first.

The NEXT_DATE function is used to determine the next occurrence of a specific day of the week after a given date._________________________

The ____________________ function allows different actions to be performed based upon whether a NULL value exists in a specified column.

Only a DATE function can be nested inside another DATE function.

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

The LENGTH function is used to determine the number of rows in a table.

To indicate that the three-letter abbreviation for day of the week should be displayed,include ____________________ in the date element format argument.

A single-row function can be used with the DUAL table.

The ____________________ function fills the area to the right of a character string with a specific character.

The TO CHAR function can be used to display insignificant zeros._________________________

Which of the following functions will truncate a numeric value to a specific position?

Which of the following functions can be used to fill a character string to a specific width?