Question 1

The DECODE function allows the user to specify different actions to be taken,depending on the value being used for the comparison.

Accepted Answer

A) True 
 B)False

Question 2

​Which of the following format elements will display the value of Friday in a specified date as a 6?

Accepted Answer

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

Question 3

​Which of the following returns one row of results for each record processed?

Accepted Answer

A)  ​single-row function 
B)  ​multiple-row function 
C)  ​aggregate function 
D)  ​all of the above 
A)  ​single-row function 
B)  ​multiple-row function 
C)  ​aggregate function 
D)  ​all of the above

Question 4

​The phonetic representation of a character string can be determined using the ____ function.

Accepted Answer

A)  ​SOUND 
B)  ​PHONETIC 
C)  ​SOUNDEX 
D)  ​SOUNDINDEX 
A)  ​SOUND 
B)  ​PHONETIC 
C)  ​SOUNDEX 
D)  ​SOUNDINDEX

Question 5

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 6

Which of the following functions determines the number of characters in a character string?​

Accepted Answer

A)  ​COUNT 
B)  ​NUMBER 
C)  ​LENGTH 
D)  ​none of the above 
A)  ​COUNT 
B)  ​NUMBER 
C)  ​LENGTH 
D)  ​none of the above

Question 7

The YR element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date._________________________​

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

​Which of the following format elements will display insignificant leading zeros?

Accepted Answer

A)  ​$999 
B)  ​0009999 
C)  ​99.999 
D)  ​9,999.990 
A)  ​$999 
B)  ​0009999 
C)  ​99.999 
D)  ​9,999.990

Question 10

​Which of the following functions can be used to substitute another value for a NULL value during calculations?

Accepted Answer

A)  ​NVL 
B)  ​NULLVAL 
C)  ​NULVAL 
D)  ​NLV 
A)  ​NVL 
B)  ​NULLVAL 
C)  ​NULVAL 
D)  ​NLV

Question 11

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 12

​To indicate that minutes should be displayed,include ____________________ in the time element format argument.

Accepted Answer

The answer of ​To indicate that minutes should be displayed,include...

Question 13

The SOUND function is used to determine the phonetic representation of a character string._________________________​

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ function removes a specific string of characters from the left side of a set of data values.

Accepted Answer

The answer of The ____________________ function removes a specific string...

Question 15

LOWER,UPPER,and INITCAP functions are all character manipulation functions.​

Accepted Answer

A) True 
 B)False

Question 16

​The ____________________ function is used to replace a specific set of characters found within a character string with another set of characters.

Accepted Answer

The answer of ​The ____________________ function is used to replace...

Question 17

The LOWER function can be used to display upper-case characters in lower-case.​

Accepted Answer

A) True 
 B)False

Question 18

The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.​

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

A Julian date is the number of days that have passed between a specific date and January 1,4712 B.C.​

Accepted Answer

A) True 
 B)False

The DECODE function allows the user to specify different actions to be taken,depending on the value being used for the comparison.

Which of the following format elements will display the value of Friday in a specified date as a 6?

Which of the following returns one row of results for each record processed?

The phonetic representation of a character string can be determined using the ____ function.

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?

Which of the following functions determines the number of characters in a character string?

The YR element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date._________________________

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

Which of the following format elements will display insignificant leading zeros?

Which of the following functions can be used to substitute another value for a NULL value during calculations?

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.

To indicate that minutes should be displayed,include ____________________ in the time element format argument.

The SOUND function is used to determine the phonetic representation of a character string._________________________

The ____________________ function removes a specific string of characters from the left side of a set of data values.

LOWER,UPPER,and INITCAP functions are all character manipulation functions.

The ____________________ function is used to replace a specific set of characters found within a character string with another set of characters.

The LOWER function can be used to display upper-case characters in lower-case.

The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.

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

A Julian date is the number of days that have passed between a specific date and January 1,4712 B.C.

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 DECODE function allows the user to specify different actions to be taken,depending on the value being used for the comparison.

​Which of the following format elements will display the value of Friday in a specified date as a 6?

​Which of the following returns one row of results for each record processed?

​The phonetic representation of a character string can be determined using the ____ function.

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?​

Which of the following functions determines the number of characters in a character string?​

The YR element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date._________________________​

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

​Which of the following format elements will display insignificant leading zeros?

​Which of the following functions can be used to substitute another value for a NULL value during calculations?

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.​

​To indicate that minutes should be displayed,include ____________________ in the time element format argument.

The SOUND function is used to determine the phonetic representation of a character string._________________________​

The ____________________ function removes a specific string of characters from the left side of a set of data values.

LOWER,UPPER,and INITCAP functions are all character manipulation functions.​

​The ____________________ function is used to replace a specific set of characters found within a character string with another set of characters.

The LOWER function can be used to display upper-case characters in lower-case.​

The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.​

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

A Julian date is the number of days that have passed between a specific date and January 1,4712 B.C.​

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

Which of the following format elements will display the value of Friday in a specified date as a 6?

Which of the following returns one row of results for each record processed?

The phonetic representation of a character string can be determined using the ____ function.

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?

Which of the following functions determines the number of characters in a character string?

The YR element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date._________________________

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

Which of the following format elements will display insignificant leading zeros?

Which of the following functions can be used to substitute another value for a NULL value during calculations?

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.

To indicate that minutes should be displayed,include ____________________ in the time element format argument.

The SOUND function is used to determine the phonetic representation of a character string._________________________

LOWER,UPPER,and INITCAP functions are all character manipulation functions.

The ____________________ function is used to replace a specific set of characters found within a character string with another set of characters.

The LOWER function can be used to display upper-case characters in lower-case.

The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.

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

A Julian date is the number of days that have passed between a specific date and January 1,4712 B.C.