12.what are the functions can return  non-null value when called with null value?

1. upper
   
2. ASCII
   
3. CONCAT
   
4. DECODE
   
5.  NVL
   

ans:C,D,E

13.select substr("the great ocp", -3) result from dual;

1. the
   
2. great
   
3. ocp
   
4. the great

ans: C

14.what is ceil(-21.3) and ceil(-21.5) ?

1. -21,-21
   
2. -22,-21
   
3. -22,-22
   
4. -22,-21

ans:A

14.what is floor(-21.3) and floor(-21.5) ?

1. -21,21
   
2. -22,-21
   
3. -22,-22
   
4. -22,-21
   

ans:c

15.The user function is a singlerowfunction which returns the current user name?

true
false

ans:true

16.Trignometric function uses?

1. radians
   
2. degrees
   
3. gradients
   
4. both radians and degrees
   

ans:A

17.which function uses if then else logic

1. decode
   
2. initcap
   
3. collace
   
4. replace
   
5. ifelse
   

ans :A

18.In group functions, the exact numer of inputs is determined after the query is executed

1. true
   
2. false
   

ans:A

19.find out the correct sequence?

1. groupby,orderby,having
   
2. having,groupby,orderby
   
3. orderby,having,groupby
   
4. groupby,having,orderby
   
5. none of the above

ans: D

19.Nesting functions are not supported.

1. true
   
2. false

ans :B

20.GROUP BY, ORDER BY can  be used in WHERE clause.

1. true
   
2. false

ans:B