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…

Using Single-Row Functions to Customize Output

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

(53 responses)

A
2% (1)
B
11% (6)
C
81% (43)
D
2% (1)
E
4% (2)

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

#ROUND#TRUNC#numeric functions#single-row functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice