Multiple choice technology databases

select trunc(10,-1) from dual would results in?

  1. 10

  2. 9

  3. ERROR

  4. 1

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

TRUNC(10, -1) truncates the number to the tens place (10s). Since 10 is already a multiple of 10, it remains unchanged. TRUNC differs from ROUND - it doesn't round up, it just truncates.