πŸ“Š MySQL
Q. Which of these take more space?
Variable length columns, Fixed length columns
  • (A) variable length
  • (B) Upto 256 bytes
  • (C) fixed length
  • (D) indeterminate
πŸ’¬ Discuss
βœ… Correct Answer: (C) fixed length

Explanation: Variable length: Variable-length columns store data in a flexible manner, allowing the storage of data of varying lengths. They only consume as much space as needed for the actual data stored. Examples include VARCHAR and TEXT data types. Variable-length columns typically take less space because they only use as much storage as necessary to accommodate the data.

Explanation by: Gopal Sharma
Variable length: Variable-length columns store data in a flexible manner, allowing the storage of data of varying lengths. They only consume as much space as needed for the actual data stored. Examples include VARCHAR and TEXT data types. Variable-length columns typically take less space because they only use as much storage as necessary to accommodate the data.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
71
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Gopal Sharma
Publisher
πŸ“ˆ
94%
Success Rate