πŸ“Š MySQL
Q. Which mode does not remove trailing spaces when CHAR values are retrieved?
  • (A) PAD_CHAR_TO_FULL_LENGTH
  • (B) MEDIUMINT UNSIGNED
  • (C) CHAR_PAD_TO_FULL_LENGTH
  • (D) PAD_CHAR_TO_LENGTH
πŸ’¬ Discuss
βœ… 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.

Explanation by: Neelam Mittal
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.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
63
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Neelam Mittal
Publisher
πŸ“ˆ
85%
Success Rate