You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?
A.
Float
B.
Money
C.
Smallmoney
D.
Decimal
Explanation:
Decimal is the only one in the list that can give a fixed precision and scale.
http://msdn.microsoft.com/en-us/library/ms187746.aspx
?
Answer = D, or could be Number datatype if that was an option instead
Numeric* sorry.
D