Microsoft
70-457 · Question #31
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?
The correct answer is D. Numeric. Numeric is the only one in the list that can give a fixed precision and scale.
Implement and Maintain Database Objects
Question
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?
Options
- AFloat
- BMoney
- CSmallmoney
- DNumeric
How the community answered
(30 responses)- A7% (2)
- B7% (2)
- C13% (4)
- D73% (22)
Explanation
Numeric is the only one in the list that can give a fixed precision and scale.
Topics
#numeric data type#fixed precision#scale#decimal
Community Discussion
No community discussion yet for this question.