Multiple choice

Evaluate the given SQL statement. SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the following values will be displayed?

  1. 46 and 45.93

  2. 50 and 45.93

  3. 50 and 45.9

  4. 45 and 45.93

  5. 45.95 and 45.93

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

ROUND(45.953, -1) rounds to 50 because the negative second parameter means round to tens place (45.953 becomes 50). TRUNC(45.936, 2) truncates to 45.93 by keeping only 2 decimal places (no rounding, just truncation).