Multiple choice technology databases

select trunc(760.5,-2) from dual returns

  1. Error

  2. 700

  3. 0

  4. 7

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

TRUNC(760.5,-2) truncates to the hundreds place (negative second decimal position), resulting in 700. The negative parameter specifies truncation to the left of the decimal point.