A column is being used to store strings of variable lengths. Performance is a concern, so the column needs to use as little space as possible. Which of the following data types best meets these requirements?
VARCHAR is a data type optimized for storing variable-length strings. It only uses the necessary space for each value, making it more efficient in terms of storage compared to CHAR, which allocates a fixed amount of space regardless of the string's actual length​.
[Reference: CompTIA Data+ DA0-001 Official Guide, , ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit