Vidyalelo
MySQL · Q1060

MySQL

Programming · MySQL · question 1060

Q1060

Which type can store a collection of objects of any type?

A.
GEOMETRYCOLLECTION
Answer
B.
MULTIPOINT
C.
MULTILINESTRING
D.
MULTIPOLYGON

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about data types in MySQL, specifically the ones used for geospatial data.
Think of these types like containers for different kinds of geographical information.
* GEOMETRYCOLLECTION is the special one. It's like a big box that can hold any kind of geographical object, like points, lines, polygons, or even other collections! * The other options – MULTIPOINT, MULTILINESTRING, and MULTIPOLYGON – are more specific. They can only store collections of one type: points, lines, or polygons, respectively. So, the answer is Option A: GEOMETRYCOLLECTION.
It's the only type in MySQL that can hold a mix of different geographical objects in a single collection.