If a column is defined as NUMBER(5,2),which of the following is true?
A) The column can store a total of 7 digits,with 5 on the left side of the decimal point,and 2 on the right.
B) The column can store a total of 7 digits,all of them on the right side of the decimal point.
C) The column can store a total of 5 digits,with 3 on the left side of the decimal point,and 2 on the right.
D) The column can store a total of 5 digits,all of them on the left side of the decimal point.

Question

If a column is defined as NUMBER(5,2),which of the following is true?​
A) ​The column can store a total of 7 digits,with 5 on the left side of the decimal point,and 2 on the right.
B) ​The column can store a total of 7 digits,all of them on the right side of the decimal point.
C) ​The column can store a total of 5 digits,with 3 on the left side of the decimal point,and 2 on the right.
D) ​The column can store a total of 5 digits,all of them on the left side of the decimal point.

Quizplus · Accepted Answer

In a NUMBER(p,s) definition, 'p' represents the total number of significant digits that the number can have, and 's' represents the number of those digits that can be after the decimal point. Therefore, for NUMBER(5,2), the column can store a total of 5 digits, with up to 3 on the left side of the decimal point and 2 on the right.

If a Column Is Defined as NUMBER(5,2),which of the Following