Question 1

The ____________________ function is used to substitute a specified value for a NULL value.

Accepted Answer

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

Question 2

LOWER, UPPER, and INITCAP functions are all $\underline {\text { character manipulation } }$functions. _________________________

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

$\underline { \text { Single-row } }$ functions return one row of results for each group or category of rows processed. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  SUBSTR 
B)  SUBSTRING 
C)  PARTSTR 
D)  PORTION 
A)  SUBSTR 
B)  SUBSTRING 
C)  PARTSTR 
D)  PORTION

Question 6

Although the ____________________ table is rarely used in the industry, it can be valuable for someone learning how to work with functions or testing new functions.

Accepted Answer

The answer of Although the ____________________ table is rarely used...

Question 7

The $\underline {\text { NVL2 }}$ function allows different options to be selected, based upon whether a NULL value exists. _________________________

Accepted Answer

A) True 
 B)False

Question 8

$\underline {\text { SYSTEMDATE } }$can be used to include the computer's date in a SQL statement. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Which of the following format argument elements indicates that the name of the day of the week for the specified date should be displayed?

Accepted Answer

A)  DDD 
B)  DD 
C)  D 
D)  DAY 
A)  DDD 
B)  DD 
C)  D 
D)  DAY

Question 10

Which of the following functions will convert the first letter of each word to an upper-case letter and the remaining letters of the word to lower-case letters?

Accepted Answer

A)  INITIALCAPITAL 
B)  INITIALCAP 
C)  UPPERFIRST 
D)  none of the above 
A)  INITIALCAPITAL 
B)  INITIALCAP 
C)  UPPERFIRST 
D)  none of the above

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Contents of the CUSTOMERS table
   
Note: The ST column name is truncated, this represents the STATE column.
-Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

Accepted Answer

A)  SELECT customer#, city, SUBSTR(state, 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL'; 
B)  SELECT customer#, city, SUBSTR( 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL'; 
C)  SELECT customer#, city, REPLACE( 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL'; 
D)  SELECT customer#, city, REPLACE(state, 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL'; 
A)  SELECT customer#, city, SUBSTR(state, 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL'; 
B)  SELECT customer#, city, SUBSTR( 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL'; 
C)  SELECT customer#, city, REPLACE( 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL'; 
D)  SELECT customer#, city, REPLACE(state, 'FL', 'FLORIDA') FROM customers
WHERE state = 'FL';

Question 13

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 14

Which of the following refers to a predefined block of code?

Accepted Answer

A)  parameters 
B)  arguments 
C)  functions 
D)  syntax 
A)  parameters 
B)  arguments 
C)  functions 
D)  syntax

Question 15

Any of the single-row functions covered in this chapter can be used with the $\underline { \text { DUAL}   }$ table. _________________________

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?

Accepted Answer

A)  DECODE 
B)  DCD 
C)  IFTHEN 
D)  SELECTIF 
A)  DECODE 
B)  DCD 
C)  IFTHEN 
D)  SELECTIF

Question 19

The ____________________ function is used to return a portion of a string.

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

The ____________________ function is used to substitute a specified value for a NULL value.

LOWER, UPPER, and INITCAP functions are all $\underline {\text { character manipulation } }$ functions. _________________________

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

$\underline { \text { Single-row } }$ functions return one row of results for each group or category of rows processed. _________________________

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

Although the ____________________ table is rarely used in the industry, it can be valuable for someone learning how to work with functions or testing new functions.

The $\underline {\text { NVL2 }}$ function allows different options to be selected, based upon whether a NULL value exists. _________________________

$\underline {\text { SYSTEMDATE } }$ can be used to include the computer's date in a SQL statement. _________________________

Which of the following format argument elements indicates that the name of the day of the week for the specified date should be displayed?

Which of the following functions will convert the first letter of each word to an upper-case letter and the remaining letters of the word to lower-case letters?

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

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

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

Which of the following refers to a predefined block of code?

Any of the single-row functions covered in this chapter can be used with the $\underline { \text { DUAL} }$ table. _________________________

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

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.

Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?

The ____________________ function is used to return a portion of a string.

When functions are nested, the outer function is solved or 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

The ____________________ function is used to substitute a specified value for a NULL value.

LOWER, UPPER, and INITCAP functions are all character manipulation ‾\underline {\text { character manipulation } } character manipulation ​ functions. _________________________

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

Single-row ‾\underline { \text { Single-row } } Single-row ​ functions return one row of results for each group or category of rows processed. _________________________

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

Although the ____________________ table is rarely used in the industry, it can be valuable for someone learning how to work with functions or testing new functions.

The NVL2 ‾\underline {\text { NVL2 }} NVL2 ​ function allows different options to be selected, based upon whether a NULL value exists. _________________________

SYSTEMDATE ‾\underline {\text { SYSTEMDATE } } SYSTEMDATE ​ can be used to include the computer's date in a SQL statement. _________________________

Which of the following format argument elements indicates that the name of the day of the week for the specified date should be displayed?

Which of the following functions will convert the first letter of each word to an upper-case letter and the remaining letters of the word to lower-case letters?

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

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

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

Which of the following refers to a predefined block of code?

Any of the single-row functions covered in this chapter can be used with the DUAL‾\underline { \text { DUAL} } DUAL​ table. _________________________

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

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.

Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?

The ____________________ function is used to return a portion of a string.

When functions are nested, the outer function is solved or 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

LOWER, UPPER, and INITCAP functions are all $\underline {\text { character manipulation } }$ functions. _________________________

$\underline { \text { Single-row } }$ functions return one row of results for each group or category of rows processed. _________________________

The $\underline {\text { NVL2 }}$ function allows different options to be selected, based upon whether a NULL value exists. _________________________

$\underline {\text { SYSTEMDATE } }$ can be used to include the computer's date in a SQL statement. _________________________

Any of the single-row functions covered in this chapter can be used with the $\underline { \text { DUAL} }$ table. _________________________