Microsoft
70-459 · Question #73
70-459 Question #73: Real Exam Question with Answer & Explanation
The correct answer is D. char(11). All customer IDs are 11 digits. The first three digits of a customer ID represent the customer's country. The remaining eight digits are the customer's account number. int: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) (just 10 digits max) bigint: -2^63 (- 9,223,372,036,854,77
Question
Which data type should you use for CustomerlD?
Options
- Avarchar(11)
- Bbigint
- Cnvarchar(11)
- Dchar(11)
Explanation
All customer IDs are 11 digits. The first three digits of a customer ID represent the customer's country. The remaining eight digits are the customer's account number. int: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) (just 10 digits max) bigint: -2^63 (- 9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
Community Discussion
No community discussion yet for this question.