Which data type should you use?

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?

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.
Numeric

Explanation:
Numeric is the only one in the list that can give afixed precision and scale.
Reference: http://msdn.microsoft.com/en-us/library/ms179882.aspx



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Umar Memon

Umar Memon

D numeric

Cyndi

Cyndi

B

Cyndi

Cyndi

I’m wrong, D is the correct one.