You need to store currency data and you know that data will always have two digits to the right of the decimal points. However the number of digits to the left of the decimal place will vary greatly. Which data type would be most appropriate to store the data?

A: NUMBER
B: NUMBER(T)
C: LANG
D: LANGRA

ANSWER: A

EXPLANATION: Answer A is correct because by default NUMBER is NUMBER(L, P) type, which is always stored as variabl length data, where 1 byte is used to store the exponent, 1 byte is used to store for every two significant digits of the number’s mantissa, and 1 byte is used for negative numbers if the number of significant digits is less than 38 bytes.

INCORRECT ANSWERS:

B: NUMBER(T) type will not allow to keep more than T numbers of digits to the left of the decimal place, but question says that it will vary greatly.
C: There is no type LANG in Oracle 8i.
D: Type LANGRA does not exists too.