Multiple choice general knowledge

In oracle what is the result of TRUNC(56.763,-2)?

  1. 100

  2. 0

  3. 50

  4. 56

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

TRUNC in Oracle with negative second parameter truncates to the left of the decimal point. TRUNC(56.763,-2) truncates 56.763 to the nearest hundred, which is 0 (since 56 rounds down to 0 at the hundreds place).