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. Small money

D. Numeric

Explanation:

Numeric is the only one in the list that can give a fixed precision and scale.

Reference: http://msdn.microsoft.com/en-us/library/ms179882.aspx

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. Small money

D. Decimal

Explanation:

Decimal is the only one in the list that can give a fixed precision and scale.

Reference: http://msdn.microsoft.com/en-us/library/ms187746.aspx

You are developing a database that will contain price information.

You need to store the prices that i

nclude a fixed precision and a scale of six digits.

Which data type should you use?

A. Real

B. Small money

C. Money

D. Decimal

Explanation:

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. Small money

B. Numeric

C. Money

D. Varchar

Explanation:

Numer

ic data types that have fixed precision and scale.

decimal[ (p[ , s] )] and numeric[ (p[ , s] )]

where

* p (precision)

The maximum total number of decimal digits that will be stored, both to the left and to the right of the decimal point. The precision mu

st be a value from 1 through the maximum precision of 38. The default precision is 18.

* (scale)

The number of decimal digits that will be stored to the right of the decimal point.

Reference: decimal and numeric (Transact-SQL)

https://msdn.microsoft.com/en-us/library/ms187746.aspx