Beginner
Database Management Systems
Q19 / 100
What is the difference between CHAR and VARCHAR?
Correct! Well done.
Incorrect.
The correct answer is B) CHAR stores fixed-length strings (padded with spaces); VARCHAR stores variable-length strings up to a maximum
B
Correct Answer
CHAR stores fixed-length strings (padded with spaces); VARCHAR stores variable-length strings up to a maximum
Explanation
CHAR(10) always stores 10 bytes (padded). VARCHAR(100) stores up to 100 bytes, using only what's needed plus 1-2 bytes for length. CHAR is slightly faster for fixed-length data like codes.
Progress
19/100