Which tasks can be performed using SQL functions that are built into Oracle database?
(Choose three.)
A.
removing trailing, leading, and embedded characters from a character string
B.
finding the remainder of a division
C.
adding a number to a date for a resultant date value
D.
comparing two expressions to check whether they are equal
E.
checking whether a specified character exists in a given string
A = MOD
B = ADD_MONTHS
C = NULLIF
D = INSTR
E = REPLACE
I am not sure why only 3 can be correct here. Anyone know?
why c is incorrect
ADD_MONTHS
function do exactly the same