Multiple choice technology databases

A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error

  1. 5392845.324

  2. 871039453.1

  3. 97234512.123

  4. 1234567.12
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

NUMBER(10,2) means total 10 digits with 2 after decimal, so max 8 digits before decimal (10-2=8). Option B has 9 digits before the decimal (871039453), which exceeds the allowed precision and causes an error. Option C has 3 decimal places but only 8 integer digits, so it would round to 97234512.12 without error. Oracle rounds values that exceed scale but fits within precision, only errors when integer part exceeds allowed digits.

Keep practicing — related questions