
Answer-first summary for fast verification
Answer: INTEGER
The **INTEGER** data type is the most suitable for associating a numerical value with each key in a SQL table. Here's why: - **INTEGER** is designed to store whole numbers efficiently, making it ideal for numerical values that don't require decimal points. - **STRUCT** is a complex type meant for collections of named fields, not for simple key-value numerical associations. - **ARRAY** stores ordered collections of elements, not suited for associating a single numerical value with a key. - **MAP** can store key-value pairs but introduces unnecessary complexity for this straightforward need. Thus, **INTEGER** stands out as the optimal choice for this scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.