Which statements are true regarding single row functions? (Choose all that apply.)
A.
MOD : returns the quotient of a division
B.
TRUNC : can be used with NUMBER and DATE values
C.
CONCAT : can be used to combine any number of values
D.
SYSDATE : returns the database server current date and time
E.
INSTR : can be used to find only the first occurrence of a character in a string
F.
TRIM : can be used to remove all the occurrences of a character from a string
Why C, E and F are not ritgh??
Why C, E, F aren’t correct?
Concat – you can concatenate only 2 values
Instr – can be used to find 1st, 2nd etc. occurence of character in string
Trim – you can remove only leading and trailing characters