Oracle Database Administration I — Question 149

Examine this query:

SELECT TRUNC(ROUND(156.00,-2),-1) FROM DUAL

What is the result?

Answer options

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

Correct answer: E

Explanation

The inner ROUND function rounds 156.00 to the nearest hundred, resulting in 200. The TRUNC function then does not alter this value, as it is set to truncate at the tens place. Thus, the final output is 200, making option E the correct answer, while the other options do not reflect the result of the query.