Multiple choice technology databases

Round(159.63,-3) and Trunc(159.63,-3) will have following Outputs respectively:

  1. 200 and 100

  2. 100 and 100

  3. 160 and 150

  4. none of the above

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

With negative precision in Round/Trunc functions, -3 means round/truncate to the nearest 1000. For value 159.63: Round(159.63, -3) = 0 (since 159 is closer to 0 than 1000) and Trunc(159.63, -3) = 0 (truncating toward zero). The correct output pair is (0, 0), which is not listed in any option, making 'none of the above' the right choice.