Q. Which mode does not remove trailing spaces when CHAR values are retrieved?
β
Correct Answer: (A)
PAD_CHAR_TO_FULL_LENGTH
Explanation: This question is about how MySQL handles spaces in CHAR data types. CHAR columns store fixed-length strings, meaning they always occupy the same amount of space, even if the actual text is shorter.