ICT8_W4-5_Quiz

What number function shortens the given number based on the decimal places needed in the code?

• Mod

• Next_Day

• Round

• Trunc

What number function rounds up the given number based on the decimal places needed in the code?

• Mod

• Next_Day

• Round

• Trunc

What date function returns the number of months between the first date value and the second date value?

• NEXT_DAY

• ROUND

• TRUNC

• MONTHS_BETWEEN

You are asked to display the exact day that is greater than the given date. What date function are you going to use?

• ADD_MONTHS

• NEXT_DAY

• ROUND

• LAST_DAY

What date functions returns the date plus the integer months?

• ADD_MONTHS

• LAST_DAY

• TRUNC

• MONTHS_BETWEEN

Alternative quote operator is used to specify the quotation mark delimiter of the user.

• True

• False

A months_between  links column or character strings to other columns.

• True

• False

An alternative operator is represented by two vertical bars ||.

• True

• False

Alternative quote operator does allow users to specify their own quotation mark delimiter and select any delimiter.

• True

• False

The Oracle number functions take a numeric input as an expression and return numeric values.

• True

• False