Which data type stores fixed-length character values?

• A. Character (CHAR)
• B. Character Varying (VARCHAR)
• C. Binary
• D. Date (format)

Answer: (A)

Fixed-length character storage is what CHAR provides. When you define a column as CHAR with a specified length, every value occupies that exact amount of space. If you store a shorter string, it’s padded to the defined length with spaces, ensuring every entry has the same width. This uniform size is useful when you know all values will be the same length, such as fixed codes or identifiers.

That’s why CHAR is the best answer here: it is designed for fixed-length character data. The other types don’t enforce a constant width. VARCHAR stores variable-length strings, using only as much space as the value contains. Binary is used for binary data rather than text, and Date is for date values, not character strings.