Multiple choice technology databases

Which of the following are the correct value for the column whose data type is declared as number(3,4)

  1. 123.21

  2. 0.001

  3. 0.01

  4. 123.01
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle NUMBER(p,s), p=precision (total significant digits), s=scale (digits after decimal). For NUMBER(3,4), precision=3 allows 3 significant digits total, with 4 decimal places. Valid: 0.01 (1 significant digit). Invalid: 123.21 (5 sig digits), 0.001 (4 decimal places), 123.01 (5 sig digits).

Keep practicing — related questions