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

What is an Oracle index?

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

How to loop through data rows in the implicit cursor?

How to resolve the ORA-39133 error in Oracle?

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

Explain what are the advantages of views?

Explain integrity constraint?

What is the maximum limit on the number of columns in a table?

How to create an oracle testing table?

How to create a stored program unit?

How to define an oracle sub procedure?

What is a proxy object?

For more Oracle General Interview Questions Click Here