Oracle Database 12c: SQL Fundamentals — Question 32

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

Answer options

• A. 16
• B. 100
• C. 160
• D. 200
• E. 150

Correct answer: C

Explanation

The query first rounds 156.00 to the nearest ten, resulting in 160. Then, TRUNC is applied, which in this case does not change the value since it is already an integer. The other options are incorrect as they do not reflect the outcome of the rounding and truncating operations.