select trunc(round(156.00,-1),-1) from dual;

Question Posted / samba

Answers were Sorted based on User's Feedback

select trunc(round(156.00,-1),-1) from dual;..

Answer / samba

160.

Is This Answer Correct ?

53 Yes

4 No

select trunc(round(156.00,-1),-1) from dual;..

Answer / rakesh anand

TRUNC(ROUND(156.00,-1),-1)
----------------------------
160

Is This Answer Correct ?

32 Yes

2 No

More Oracle General Interview Questions

types of indexes and the rationale behind choosing a particular index for a situation.

what is the uses of cusor

How to load excel data sheet to oracle database

6. Display the client name and order date for all orders using the traditional method.

various types of joins

How oracle handles dead locks?

What is a trigger and what are its types?

Describe varray?

Do you know about aggregate functions? What is row num function? Can it be used all databases?

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

what is the syntax of ALTER command?

does Oracle has only one table space?

For more Oracle General Interview Questions Click Here