Which statements are true regarding single row functions?

Which statements are true regarding single row functions? (Choose all that apply.)

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Ivan Ticona

Ivan Ticona

Why C, E and F are not ritgh??

Ivan Ticona

Ivan Ticona

Why C, E, F aren’t correct?

Justyna

Justyna

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