Multiple choice technology web technology

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

  1. 0.001

  2. 3.01

  3. 0.01

  4. 0.1
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

NUMBER(3,-1) in Oracle means precision 3, scale -1. Negative scale rounds to the left of the decimal point. Scale -1 rounds to the nearest 10. So 0.001 rounds to 0, which is valid. 0.01 rounds to 0, but has only 2 significant digits. 0.1 has 1 significant digit. 0.001 has exactly 3 significant digits and when rounded to scale -1 becomes 0, which satisfies NUMBER(3,-1).

Keep practicing — related questions