Question 1

The ____________________ function converts character strings to lower-case letters.

Accepted Answer

The answer of The ____________________ function converts character strings to...

Question 2

The NVL function can be used to include records containing null values in calculations.

Accepted Answer

A) True 
 B)False

Question 3

The $\underline { \text { RTRIM } }$ function can be used to remove a specific set of characters from the right side of a set of data values. _________________________

Accepted Answer

A) True 
 B)False

Question 4

The ____________________ function is used to combine two sets of character strings into one set.

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

A Julian date represents the number of $\underline {\text { hours } }$ that have passed since January 1, 4712 B.C. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements will produce the value 21.1?

Accepted Answer

A)  SELECT ROUND(21.12, 1) FROM dual; 
B)  SELECT ROUND(21.12, -1) FROM dual; 
C)  SELECT ROUND(21.12, 0) FROM dual; 
D)  none of the above 
A)  SELECT ROUND(21.12, 1) FROM dual; 
B)  SELECT ROUND(21.12, -1) FROM dual; 
C)  SELECT ROUND(21.12, 0) FROM dual; 
D)  none of the above

Question 8

Which of the following is a table provided in Oracle which can be helpful for testing functions?

Accepted Answer

A)  DUMMY 
B)  DUM 
C)  DUAL 
D)  EMPTY 
A)  DUMMY 
B)  DUM 
C)  DUAL 
D)  EMPTY

Question 9

The CONCAT function is used to store the contents of two columns into one column.

Accepted Answer

A) True 
 B)False

Question 10

When a function is used in a SELECT statement, it only affects how the data are displayed in the results.

Accepted Answer

A) True 
 B)False

Question 11

The $\underline { \text { NULLIF } }$ function is often combined with the NVL2 function to display a descriptive status. _________________________

Accepted Answer

A) True 
 B)False

Question 12

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.

Accepted Answer

A) True 
 B)False

Question 13

The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified width.

Accepted Answer

A) True 
 B)False

The ____________________ function converts character strings to lower-case letters.

The NVL function can be used to include records containing null values in calculations.

The $\underline { \text { RTRIM } }$ function can be used to remove a specific set of characters from the right side of a set of data values. _________________________

The ____________________ function is used to combine two sets of character strings into one set.

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

A Julian date represents the number of $\underline {\text { hours } }$ that have passed since January 1, 4712 B.C. _________________________

Which of the following statements will produce the value 21.1?

Which of the following is a table provided in Oracle which can be helpful for testing functions?

The CONCAT function is used to store the contents of two columns into one column.

When a function is used in a SELECT statement, it only affects how the data are displayed in the results.

The $\underline { \text { NULLIF } }$ function is often combined with the NVL2 function to display a descriptive status. _________________________

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.

The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified 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 converts character strings to lower-case letters.

The NVL function can be used to include records containing null values in calculations.

The RTRIM ‾\underline { \text { RTRIM } } RTRIM ​ function can be used to remove a specific set of characters from the right side of a set of data values. _________________________

The ____________________ function is used to combine two sets of character strings into one set.

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

A Julian date represents the number of hours ‾\underline {\text { hours } } hours ​ that have passed since January 1, 4712 B.C. _________________________

Which of the following statements will produce the value 21.1?

Which of the following is a table provided in Oracle which can be helpful for testing functions?

The CONCAT function is used to store the contents of two columns into one column.

When a function is used in a SELECT statement, it only affects how the data are displayed in the results.

The NULLIF ‾\underline { \text { NULLIF } } NULLIF ​ function is often combined with the NVL2 function to display a descriptive status. _________________________

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.

The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified 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 $\underline { \text { RTRIM } }$ function can be used to remove a specific set of characters from the right side of a set of data values. _________________________

A Julian date represents the number of $\underline {\text { hours } }$ that have passed since January 1, 4712 B.C. _________________________

The $\underline { \text { NULLIF } }$ function is often combined with the NVL2 function to display a descriptive status. _________________________