1Z0-771 practice question 14 of 15

Which is NOT an available Geometry Column data type for the map region?

Full set: 211 questions
Answer options
A: GeoJSON
B: SDO_GEOMETRY
C: JSON OBJECT Correct answer
D: Latitude/Longitude
Correct Answer:
C. JSON OBJECT
Explanation

Oracle APEX map regions can source their geometry from several specific data types. These include Oracle's native SDOGEOMETRY type, VARCHAR2 or CLOB columns containing data in GeoJSON format, and two separate NUMBER columns representing Latitude and Longitude. A generic "JSON OBJECT" is not a recognized or supported data type for the geometry column itself. While GeoJSON is a specific format of a JSON object, APEX requires that specific structure, not just any arbitrary JSON.

Why Incorrect

A. GeoJSON is a supported format for geometry data, typically stored in a VARCHAR2 or CLOB column, which the map region can parse and display.
B. SDOGEOMETRY is the primary, native Oracle Spatial data type and is fully supported as a geometry source for map regions.
D. APEX map regions can be created directly from two NUMBER columns, one for latitude and one for longitude, which is a common use case.

References

1. Oracle APEX App Builder User's Guide, 23.2, "Managing Maps," Section 13.10.3.3, "About Map Location Sources." This section details the supported location sources, including a table with a geometry column (SDOGEOMETRY), a VARCHAR2 column containing GeoJSON, or separate latitude and longitude columns.

Scroll to Top