Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.)
A. finding the remainder of a division
B. adding a number to a date for a resultant date value
C. comparing two expressions to check whether they are equal
D. checking whether a specified character exists in a given string
E. removing trailing, leading, and embedded characters from a character string
I think all correct.
A can use mod
B can use add_months
C can use nullif
D can use instr
E can use trim
What about B ?
select sysdate + 1 from dual
select add_months(sysdate, 1) from dual
I think B is correct too
correct answer CDE
ACD is correct, for E it should be trailing, leading and both.
TRIM can trim leading and trailing characters
REPLACE can remove everything inside,
so E is also correct answer
You should proposition one function for each case. TRIM and REPLACE – two functions. So “E” incorrect