You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?
Use char when the sizes of the column data entries are consistent.
Use varchar when the sizes of the column data entries vary considerably.
Use varchar(max) when the sizes of the column data entries vary considerably, and the string length might exceed 8,000 bytes.
This section is not available anymore. Please use the main Exam Page.98-364 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
jrn1992
Highly Voted 5 years agorogeriosolano
Most Recent 2 years, 11 months agoelkreationZ
3 years, 11 months agoYorkatta
4 years, 3 months agomarmich
4 years, 5 months agorinost
4 years, 6 months agoAntidotE
4 years, 6 months ago