Multiple choice technology databases

select round(139.898,-2),round(188.898,-2) from dual would results in?

  1. 139.89,188.89

  2. 100,200

  3. -139.89,-188.89

  4. 140,189

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

ROUND(number, -2) rounds to the hundreds place. ROUND(139.898, -2) = 100 (139 rounds down to 100). ROUND(188.898, -2) = 200 (188 rounds up to 200). The negative second parameter specifies the decimal place to round to - negative means left of decimal point.