Which tasks can be performed using SQL functions that are built into Oracle database?

Which tasks can be performed using SQL functions that are built into Oracle database? (Choose
three.)

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



Leave a Reply 16

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


hwfurlan

hwfurlan

Why E is wrong? For me C is wrong.

slzcgxc

slzcgxc

i don’t know,but C is right.

xuzhiyuan

xuzhiyuan

[ embedded characters] is not supported for trim function
but why B is wrong ?
I can execute [select sysdate + 1 from dual;] without problem

xuzhiyuan

xuzhiyuan

maybe they want a function not an operator, so B is wrong

Ramesh

Ramesh

i think nullif function can be used for comparing two expression

David

David

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;

Khalid

Khalid

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?

Helter

Helter

..not in a sense of any number, only -12 – +12

Helter

Helter

..sorry not correct prev remark: actually each number in this range could be multiplied by 10**n..

Sagar

Sagar

A = MOD
B = ADD_MONTHS
C = NULLIF
D = INSTR

So all the 4 above answers should be correct. Please modify the question.

kellar

kellar

Sorry Embedded characters cannot be removed by trim.
So i think A,B,C and D are right

reel

reel

I think replace function can remove embedded characters also.So for E-Replace

Alisha

Alisha

why b is wrong?

Adiphotog

Adiphotog

Option D should be correct as replace function can be used, see below example:

SQL> select replace(‘sTests’,’s’) from dual;

REP

Tet

Jenny

Jenny

I think the answers are A, B, C y D.