Deck 10: Selected Single Row Functions

Question 1

The ADD_MONTHS function is used to add one month to a specified date.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.

Answer 3

True

Question 4

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

Question 5

Case conversion functions can only be used in the SELECT clause of a SELECT statement.

Question 6

Character functions can be used to change the case of characters or to manipulate characters.

Question 7

The INSTR function is used to return a portion of a character string.

Question 8

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

Question 9

Single-row functions return one row of results for each group or category of rows processed.

Question 10

The INITIALCAP function can be used to convert character strings to mixed-case characters.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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.

Question 18

The MONTHS_BETWEEN function can be used to determine the number of months between two dates.

Question 19

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

Question 20

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

Question 21

The $\underline { \text { SUBSTR } }$ function is used to substitute one character string for another in a set of data. _________________________

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

The $\underline { \text { UPPER } }$ function can be used to display upper-case characters in lower-case. _________________________

Question 27

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

Question 28

You can determine the number of characters in a column by using the $\underline {\text { COUNT } }$ function. _________________________

Question 29

The TO_CHAR function can be used to add a dollar sign ($) to a numeric value.

Question 30

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

Question 31

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

Question 32

The $\underline { \text { CONCAT } }$ function can be used to concatenate the data contained in two columns. _________________________

Question 33

$\underline { \text { INITCAP } }$ can be used to convert character strings to mixed-case characters. _________________________

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

To indicate that the numeric value of the day of the year for a date is being specified, include DAY in format argument of the TO_DATE function.

Question 39

The $\underline { \text { SUBSTR } }$ function is used to return a portion of a character string. _________________________

Question 40

To add a series of asterisks (*) to a column with the intent of extending it to a specific length, you can use the $\underline {\text { LPAD or RPAD }}$ function. _________________________

Question 41

The $\underline {\text { SOUND } }$ function is used to determine the phonetic representation of a character string. _________________________

Question 42

Which of the following functions can be used to convert a character string to upper-case letters?

A) UPPER
B) UP
C) UPPERCASE
D) UPPERCAP

Question 43

Including $\underline {\text { MONTH } }$ in the format argument of the TO_DATE function indicates that the month is spelled out in the specified date. _________________________

Question 44

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

Question 45

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

Question 46

The $\underline {\text { ROUND } }$ function can be used to truncate numeric data. _________________________

Question 47

Include $\underline {\text { DAY } }$ in a format argument of the TO_CHAR function to spell out the day of the week in the specified date. _________________________

Question 48

Which of the following is an accurate statement?

A) When the LOWER function is used in a SELECT clause, it will automatically store the data in lower-case letters in the database table.
B) When the LOWER function is used in a SELECT clause, the function stays in effect for the remainder of that user's session.
C) When the LOWER function is used in a SELECT clause, the function only stays in effect for the duration of that SQL statement.
D) none of the above

Question 49

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

Question 50

When functions are nested, the $\underline {\text { inner }}$ function is solved first. _________________________

Question 51

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

Question 52

The $\underline {\text { ROUND } }$ function can be used to round numeric data to the left or right of the decimal point. _________________________

Question 53

The $\underline {\text { NEXT DATE } }$ function is used to determine the next occurrence of a specific day of the week after a given date. _________________________

Question 54

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

Question 55

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

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

Question 56

Which of the following functions can be used to convert a character string to lower-case letters?

A) LOW
B) LOWER
C) SMALLER
D) SMALLCAP

Question 57

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

Question 58

The $\underline {\text { TO CHAR } }$ function can be used to display insignificant zeros. _________________________

Question 59

The format argument in the TO_CHAR function must be enclosed in $\underline {\text { double }}$ quotation marks. _________________________

Question 60

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

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

Question 61

Which of the following functions can be used to change the format of a date that has been entered by a user to the default storage format use by Oracle11g?

A) TO_CHAR
B) TO_DATE
C) DEFAULT
D) DATE

Question 62

Which of the following represents the number of days that have passed since January 1, 4712 B.C.?

A) Cartesian date
B) Julian date
C) Extended date
D) none of the above

Question 63

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

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

Question 64

Which of the following functions can be used to determine the next occurrence of a specific day of the week after a given date?

A) NEXT_DATE
B) DATE_NEXT
C) NEXT_DAY
D) NEXT_DDD

Question 65

Which of the following functions is similar to using the (| |) symbol to combine the contents of two character strings?

A) CONCAT
B) CONCATENATION
C) CAT
D) CONCATEN

Question 66

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

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

Question 67

Which of the following functions will round the numeric data to no decimal places?

A) ROUND(34.21, 1)
B) ROUND(34.21, -1)
C) ROUND(34.21, NONE)
D) ROUND(34.21, 0)

Question 68

Which of the following functions can be used to remove a specific set of characters from the left side of a set of data values?

A) LTRIM
B) RTRIM
C) FULLTRIM
D) both a and b

Question 69

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

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

Question 70

Which of the following statements will produce the value 21.1?

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 71

Which of the following functions is used to determine the number of months between two date values?

A) MONTH_BETWEEN
B) MONTHS_BETWEEN
C) MTH_BETWEEN
D) MNTH_BETWEEN

Question 72

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

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

Question 73

Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

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

Question 74

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

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

Question 75

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

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

Question 76

Which of the following functions can be used to determine the date one month after a specified date?

A) ADD_MONTH
B) ADD_MONTHS
C) ONE_MONTH
D) NEXT_MONTH

Question 77

What is the maximum number of columns or character strings that can be combined through a single CONCAT function?

A) two
B) three
C) four
D) eight

Question 78

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

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

Question 79

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) INITIALCAPITAL
B) INITIALCAP
C) UPPERFIRST
D) none of the above

Question 80

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

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