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

The correct answer is C. 160. 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 TRUNC(column|expression, n) Truncates the column, expression, or value to…

Install and Administer Oracle RAC

Question

Evaluate the following query:

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

Options

A16
B100
C160
D200
E150

How the community answered

(35 responses)

A
3% (1)
B
3% (1)
C
77% (27)
D
6% (2)
E
11% (4)

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 TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or, if n is omitted, n defaults to zero

Topics

#TRUNC function#ROUND function#numeric functions#nested functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice