Oracle Database SQL — Question 75

Examine this query:

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

What is the result?

Answer options

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

Correct answer: B

Explanation

The query first rounds 156.00 to the nearest hundred, resulting in 200. Then, the TRUNC function with a negative value of -1 does not modify the rounded value since it is already a whole number. The other options are incorrect as they do not represent the output of the provided SQL query.