Which two statements are true about single row functions? (Choose two.)
Which two statements are true about single row functions? (Choose two.)
CEIL can indeed be used for both positive and negative numbers, and MOD returns the remainder of a division operation. CONCAT cannot be used to combine any number of values; it typically works with two arguments. FLOOR does not return the smallest integer greater than or equal to a specified number; it returns the largest integer less than or equal to the specified number. TRUNC can be used with both DATE and NUMBER data types, not just NUMBER.
AB are the correct answers
agree that. E - can be used number and also date data type.
when are you preparing to take the exams
C – false, max 2 arguments D – false, returns biggest integer smaller than specified number E – false, can be also used with DATE datatype
agree with nautil2, E. TRUNC: can be used only with NUMBER data types. This statement is incorrect. TRUNC can be used with both NUMBER and DATE data types. It truncates to the specified precision for numbers, and to the specified date component for dates
A and B are correct in my opinion.
THERE ONLY 1 ANSWER WHICH IS A
*error it should be AB