What would be the outcome?

Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1)
FROM DUAL;
What would be the outcome?

Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1)
FROM DUAL;
What would be the outcome?

A.
16

B.
100

C.
160

D.
200

E.
150

Explanation:

Function Purpose
ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places
or, if n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are
rounded.) TRUNC(column|expression, n) Truncates the column, expression, or value to n
decimal places or, if n is omitted, n defaults to zero



Leave a Reply 1

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


Surersh

Surersh

Round(156,-1) = 160 then tunc(160,-1) = 160