Always store two or three dimensional point data in SDO_POINT. To ensure less storage and faster query access to such point data, set SDO_ELEM_INFO andSDO_ORDINATES -
The Spatial routing engine must have the following tables in its schema: EDGE, NODE, PARTITION, and SIGN_POST. Which table will contain the name and numbers of the highway exists?
In the following function, what is the location?
The J2EE geocoder processes geocoding requests and generates responses. To enable this geocoding service, which file (in $ORACLE_HOME/md/jlib) must be deployed in your application server?
When using a partitioned index on a spatially partitioned table, a first level of optimization is performed making use of SDO_ROOT_MBR in the spatial index metadata. What is this optimization called?
The match mode for a geocoding operation determines how closely the attributes of an input address must match the data stored in the geocoder schema. Which attribute would you use so that the geocoder can deliver results despite any discrepancies in the input address?MATCHMODE -
