Oracle
1Z0-074 · Question #88
Examine this query: SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL; What is the result?
The correct answer is E. 150. Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm
Administering a Multitenant Container Database
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
(27 responses)- A4% (1)
- C11% (3)
- D4% (1)
- E81% (22)
Explanation
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm
Topics
#ROUND function#TRUNC function#numeric functions#SQL functions
Community Discussion
No community discussion yet for this question.