Question 1
Which function call would return the area of a geometry, geom1, in square kilometers?
SDO_GEOM.SDO_AREA(geom1, .05)
SDO_GEOM.SDO_AREA(geom1, .05, ‘unit=SQ_KM’)
SDO_GEOM.SDO_AREA(geom1, ‘unit=SQ_KM’)
SDO_GEOM.SDO_AREA_SQ_KM(geom1, .05)
SDO_GEOM.SDO_AREA_SQ_KM(geom1)
Correct answer: B
Explanation:
SDO_GEOM.SDO_AREA Format SDO_GEOM.SDO_AREA( geom IN SDO_GEOMETRY, dim IN SDO_DIM_ARRAY [, unit IN VARCHAR2] ) RETURN NUMBER; or SDO_GEOM.SDO_AREA( geom IN SDO_GEOMETRY, tol IN NUMBER [, unit IN VARCHAR2] ) RETURN NUMBER; Description Returns the area of a two-dimensional polygon. Parameters geom Geometry object. dim Dimensional information array corresponding to geom, usually selected from one of the xxx_SDO_GEOM_METADATA views. unit Unit of measurement: a quoted string with unit= and an SDO_UNIT value from the MDSYS.SDO_AREA_UNITS table (for example, 'unit=SQ_KM').If this parameter is not specified, the unit of measurement associated with the data is assumed. For geodetic data, the default unit of measurement is square meters. tol Tolerance value References: https://docs.oracle.com/database/121/SPATL/sdo_geom-sdo_area.htm#SPATL1110
SDO_GEOM.SDO_AREA
Format
SDO_GEOM.SDO_AREA(
geom IN SDO_GEOMETRY,
dim IN SDO_DIM_ARRAY
[, unit IN VARCHAR2]
) RETURN NUMBER;
or
SDO_GEOM.SDO_AREA(
geom IN SDO_GEOMETRY,
tol IN NUMBER
[, unit IN VARCHAR2]
) RETURN NUMBER;
Description
Returns the area of a two-dimensional polygon.
Parameters
geom
Geometry object.
dim
Dimensional information array corresponding to geom, usually selected from one of the xxx_SDO_GEOM_METADATA views.
unit
Unit of measurement: a quoted string with unit= and an SDO_UNIT value from the MDSYS.SDO_AREA_UNITS table (for example, 'unit=SQ_KM').
If this parameter is not specified, the unit of measurement associated with the data is assumed. For geodetic data, the default unit of measurement is square meters.
tol
Tolerance value
References: https://docs.oracle.com/database/121/SPATL/sdo_geom-sdo_area.htm#SPATL1110