Oracle Cloud Infrastructure 2023 Architect Associate — Question 36

Which native data type is used to store spatial information?

Answer options

• A. GEO_JSON
• B. SDO_RELATE
• C. SDO_LOCATION
• D. SDO_GEOMETRY

Correct answer: D

Explanation

The correct answer is D, SDO_GEOMETRY, which is specifically designed for representing geometric shapes and spatial information in databases. Options A, B, and C do not serve this primary function; GEO_JSON is a format for encoding geographic data structures, SDO_RELATE is used for spatial relationships, and SDO_LOCATION is not a standard data type for storing spatial information.