Question 1

Including MONTH in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date._________________________​

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

​Which of the following format model elements can be used to spell out a number?

Accepted Answer

A)  ​TH 
B)  ​STRING 
C)  ​SP 
D)  ​SP# 
A)  ​TH 
B)  ​STRING 
C)  ​SP 
D)  ​SP#

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The ____________________ function is used to determine the number of months between two dates.​

Accepted Answer

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

Question 8

Use MON in the format argument to spell out the specified month.​

Accepted Answer

A) True 
 B)False

Question 9

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 10

​Which of the following functions allows for different options,depending upon whether a NULL value exists?

Accepted Answer

A)  ​NVL 
B)  ​IFNL 
C)  ​IFNVL 
D)  ​NVL2 
A)  ​NVL 
B)  ​IFNL 
C)  ​IFNVL 
D)  ​NVL2

Question 11

​You can determine the number of characters in a column by using the COUNT function._________________________

Accepted Answer

A) True 
 B)False

Question 12

​When functions are nested,the ____ function is solved first.

Accepted Answer

A)  ​single-row 
B)  ​multiple-row 
C)  ​inner 
D)  ​outer 
A)  ​single-row 
B)  ​multiple-row 
C)  ​inner 
D)  ​outer

Question 13

​If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT clause,which of these functions will be executed first?

Accepted Answer

A)  ​TO_CHAR 
B)  ​SUBSTR 
C)  ​MONTH 
D)  ​YYYY 
A)  ​TO_CHAR 
B)  ​SUBSTR 
C)  ​MONTH 
D)  ​YYYY

Including MONTH in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date._________________________

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

Which of the following format model elements can be used to spell out a number?

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

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

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

The ____________________ function is used to determine the number of months between two dates.

Use MON in the format argument to spell out the specified month.

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

Which of the following functions allows for different options,depending upon whether a NULL value exists?

You can determine the number of characters in a column by using the COUNT function._________________________

When functions are nested,the ____ function is solved first.

If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT clause,which of these functions will be executed first?

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 in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date._________________________​

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

​Which of the following format model elements can be used to spell out a number?

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

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

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

The ____________________ function is used to determine the number of months between two dates.​

Use MON in the format argument to spell out the specified month.​

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

​Which of the following functions allows for different options,depending upon whether a NULL value exists?

​You can determine the number of characters in a column by using the COUNT function._________________________

​When functions are nested,the ____ function is solved first.

​If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT clause,which of these functions will be executed first?

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 MONTH in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date._________________________

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

Which of the following format model elements can be used to spell out a number?

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

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

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

The ____________________ function is used to determine the number of months between two dates.

Use MON in the format argument to spell out the specified month.

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

Which of the following functions allows for different options,depending upon whether a NULL value exists?

You can determine the number of characters in a column by using the COUNT function._________________________

When functions are nested,the ____ function is solved first.

If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT clause,which of these functions will be executed first?