nerdexam
Oracle

1Z0-071 · Question #360

Examine this query: SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL; What is the result?

The correct answer is E. 150. https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm

Using Single-Row Functions to Customize Output

Question

Examine this query:

SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL; What is the result?

Options

  • A16
  • B200
  • C100
  • D160
  • E150

How the community answered

(34 responses)
  • A
    6% (2)
  • B
    15% (5)
  • C
    3% (1)
  • D
    3% (1)
  • E
    74% (25)

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm

Topics

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

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-071 Practice