You need to design a table for a customer management application that will store a list of country names. The table must meet the following requirements:
• Country names must be stored in English only.
• The disk space used to store the table must be minimized.
Which table design should you use?
A.
B.
C.
D.
CHAR is for fixed length – some country codes might be 1 character. Use VARCHAR to save storage space.
I would stick with C.
the correct answer is A char is perfect for fixed-length fields