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
Why E is wrong? For me C is wrong.
i don’t know,but C is right.
[ embedded characters] is not supported for trim function
but why B is wrong ?
I can execute [select sysdate + 1 from dual;] without problem
maybe they want a function not an operator, so B is wrong
i think nullif function can be used for comparing two expression
E is misleading and can be a valid choice for me.
Whereas trim will not take care of embedded characters, replace can make the job:
select replace(‘*****rttihegeh***etiyrity***’,’*’) from dual;
Dear All
Option B is correct because “add_months” function can add number of months in a date and return date value.
Please help me, am i correct?
..not in a sense of any number, only -12 – +12
..sorry not correct prev remark: actually each number in this range could be multiplied by 10**n..
A = MOD
B = ADD_MONTHS
C = NULLIF
D = INSTR
So all the 4 above answers should be correct. Please modify the question.
E=TRIM
Sorry Embedded characters cannot be removed by trim.
So i think A,B,C and D are right
I think replace function can remove embedded characters also.So for E-Replace
why b is wrong?
Option D should be correct as replace function can be used, see below example:
SQL> select replace(‘sTests’,’s’) from dual;
REP
—
Tet
I think the answers are A, B, C y D.