Multiple choice technology databases

Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?

  1. 46 and 45

  2. 46 and 45.93

  3. 50 and 45.93

  4. 50 and 45.9

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ROUND(45.953, -1) rounds to the tens place (negative precision means left of decimal): 45.953 becomes 50 because it's closer to 50 than 40. TRUNC(45.936, 2) truncates to 2 decimal places: 45.936 becomes 45.93 (truncates, doesn't round). Result: 50 and 45.93.