Deck 10: Selected Single-Row Functions

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

The SUBSTR function is used to return a portion of a character string._________________________​

Question 28

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

Question 29

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

Question 30

The RTRIM function can be used to remove a specific set of characters from the right side of a set of data values._________________________​

Question 31

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

Question 32

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 33

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

Question 34

The CONCAT function can be used to concatenate the data contained in two columns._________________________​

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

INITCAP can be used to convert character strings to mixed-case characters._________________________​

Question 41

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

Question 42

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

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

Question 44

​Any of the single-row functions covered in this chapter can be used with the DUAL table._________________________

Question 45

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 46

The ROUND function can be used to truncate numeric data._________________________​

Question 47

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 48

The NULLIF function is often combined with the NVL2 function to display a descriptive status._________________________​

Question 49

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 50

The NVL2 function allows different options to be selected,based upon whether a NULL value exists._________________________​

Question 51

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

Question 52

The format argument in the TO_CHAR function must be enclosed in double quotation marks._________________________​

Question 53

SYSTEMDATE can be used to include the computer's date in a SQL statement._________________________​

Question 54

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

Question 55

When functions are nested,the inner function is solved first._________________________

Question 56

Include DAY in a format argument of the TO_CHAR function to spell out the day of the week in the specified date._________________________​

Question 57

A Julian date represents the number of hours that have passed since January 1,4712 B.C._________________________​

Question 58

The ROUND function can be used to round numeric data to the left or right of the decimal point._________________________​

Question 59

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

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

Question 60

The TO CHAR function can be used to display insignificant zeros._________________________​

Question 61

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

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 63

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

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

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

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

Question 66

​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

Question 67

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

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

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

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

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

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

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 74

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

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

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

Question 76

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

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 78

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 79

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

​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