Oracle Spatial 11g Essentials

Oracle Spatial 11g Essentials

The Oracle Spatial 11g Essentials (1Z0-595) exam is primarily intended for professionals who possess a strong technical background and exposure to Oracle Spatial 11g implementation. This certification exam covers topics such as: Oracle Spatial Concepts and Data Structures; Loading and Validating Spatial Data; Indexing Spatial Data; Performing Spatial Queries; Performing Spatial Processing; Oracle Fusion Middleware MapViewer; Geocoding, Routing, Spatial Analysis and Mining; Web Services; Advanced Indexing (Partitioning, Parallelism, Function-Based Indexes); Using Linear Referencing and Network and Topology Models; GeoRaster; Managing 3D and Lidar Data; Performance and Tuning / Exadata; and Workspace Manager. This certification differentiates candidates in the marketplace by providing a competitive edge through proven expertise. Up-to-date training and field experience are recommended.

This certification is available to all candidates but is geared toward members of the Oracle PartnerNetwork. OPN members earning this certification will be recognized as OPN Certified Specialists. This certification qualifies as competency criteria for the Oracle Spatial 11g Specialization.

Exam Number:
120 minutes
Associated Certifications:
Oracle Spatial 11g Certified Implementation Specialist

OPN Certified Specialist
Number of
Exam Price:
US $245

More on exam pricing

Passing score subject to change. View Details
Exam Validation:
Exam validated against release 11g
Exam Format:
Multiple Choice


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
OPN Guided Learning Path
Oracle Spatial 11g Implementation Specialist
Oracle University Training
Oracle Spatial: Essentials AND
Oracle Spatial: Advanced


Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)


Exam Topics

Oracle Spatial Concepts and Data Structures

  • Describe the data types, data models, coordinate systems, indexing structure, query model, and types of spatial queries
  • Describe the Oracle Spatial schema and how spatial data is represented in the database
  • Explain spatial metadata structures and views
  • Explain coordinate systems and unit support, including Oracle data structures

Loading and Validating Spatial Data

  • Load spatial data from text files using SQL Loader and external tables
  • Load spatial data from GIS files using Oracle Map Builder, Oracle shapefile loader and GDAL/OGR
  • Perform transactional inserts
  • Describe data validation and correction routines in Oracle Spatial
  • Use export and import utilities to move spatial data between databases
  • Move spatial data between databases by using transportable tablespaces

Indexing Spatial Data

  • Explain R-tree indexing concepts, how R-tree indexes are built, and index structures
  • Create indexes, set index parameters, and create indexes in parallel
  • Describe index metadata and find index size

Performing Spatial Queries

  • Explain the differences between spatial operators and spatial functions
  • Write queries to determine spatial relationships and return geometries using SDO_RELATE and SDO_FILTER operators
  • Write queries returning results within a specific distance and nearest neighbors
  • Write queries finding correlations between two spatial layers
  • Write queries combining spatial and non-spatial criteria

Performing Spatial Processing

  • Perform area, length, and distance calculations using spatial functions
  • Create buffers, combine geometries, and derive geometries
  • Use spatial aggregate functions
  • Describe the functions for arc densification and coordinate transformation
  • Use spatial utility functions
  • Describe the functions for conversion from/to OGC formats
  • Generate GML documents from spatial objects
  • Modify geometries using PL/SQL
  • Use the Java API to work with geometries

Oracle Fusion Middleware MapViewer

  • Explain the use of Oracle Fusion Middleware MapViewer
  • Describe the architecture of MapViewer
  • Install, configure, and administer MapViewer using OC4J and WebLogic Server
  • Define maps using styles, themes, and maps v
  • Define and manage tile caches v
  • Build applications using the Oracle Maps tutorial
  • Integrate external data
  • Define and access OGC Web Mapping Service and Web Feature Services

Geocoding, Routing, Spatial Analysis and Mining

  • Describe geocoding concepts, process, and functionality provided in Oracle Spatial
  • Describe the geocoding data model
  • Describe geocoding functions and structure of address results
  • Explain point addressing, structured address geocoding, and reverse geocoding
  • Install, configure, and use geocoding services with the XML API
  • Describe where to obtain data to use with the geocoding and routing engines v
  • Describe the capabilities and architecture of the routing engine
  • Describe the routing engine tables
  • Install and configure the routing engine
  • Formulate XML route requests and describe the structure of route responses
  • Explain the concept of network partitioning
  • Partition the network used by the routing engine
  • Describe the uses and capabilities of the spatial analysis and mining functions

Web Services

  • Describe the four major Open Geospatial Consortium standards for spatial web services and the services they enable
  • Describe the architecture, configuration steps, and example queries for Web Mapping Service for Oracle Database
  • Describe the architecture, configuration steps, and example queries for Oracle Database for Web Feature Service
  • Use WMS/WFS themes in MapViewer applications
  • Describe the architecture, configuration steps, and example queries for Oracle Database for Open Location Services
  • Describe the architecture, configuration steps, and example queries for Oracle Database for Catalog Service
  • Explain the Oracle licensing requirements

Advanced Indexing (Partitioning, Parallelism, Function-Based Indexes)

  • Explain the concept of table and index partitioning
  • Describe the benefits of partitioning for spatial tables
  • Partition a spatial index using range partitioning
  • Partition spatial data based on location
  • Explain why spatial queries achieve performance benefits from partitioned indexes
  • Create indexes in parallel
  • Explain where parallel query is supported
  • Describe a spatial function-based index
  • Create a spatial function-based index

Using Linear Referencing and Network and Topology Models

  • Explain linear referencing concepts, use cases, and data structures
  • Convert geometries to LRS structures and use the main dynamic segmentation, point, and validation functions
  • Describe network modeling concepts, use cases, and data structures
  • Define, load, and manage networks in the Oracle Spatial network data model using the PL/SQL API
  • Explain the concept of load-on-demand and network partitioning
  • Describe network analysis functions available with the load-on-demand Java API for analysis
  • Use the network tutorial to build an application using network analysis
  • Describe topology data model concepts, advantages, use cases, and storage model
  • Define and load topologies, define features, and perform topology queries and editing using the PL/SQL and Java APIs


  • Describe raster data concepts
  • Describe the Oracle Spatial GeoRaster storage model, including logical and physical structures
  • Explain the compression techniques available and their benefits
  • Load, export, use, and manage rasters in Oracle Spatial GeoRaster
  • Use the open source GDAL/OGR library and tools to load and export rasters between other data formats and GeoRaster
  • View/manage raster data by using the features of the GeoRaster viewing tool
  • Describe the GeoRaster functions for managing and manipulating rasters, and the Java API features and functions
  • Describe available 3rd party and open source GeoRaster processing and analysis tools available
  • Use MapViewer to display rasters and overlay them with vectors

Managing 3D and Lidar Data

  • Describe 3D data concepts, objects/models supported by Oracle Spatial, coordinate systems, and data structures for modeling surfaces/solids
  • Explain the 3D operations available, and how to transform 2D data to 3D
  • Convert data into CityGML and KML for publishing and viewing, load CityGMLdata, and query 3D data using SQL
  • Describe point clouds and their storage model
  • Load point clouds and describe point cloud processing functions
  • Describe triangulated irregular network (TIN) concepts and storage model, and available functions for data management/extraction/conversion

Performance and Tuning / Exadata

  • Describe key tips on spatial indexing
  • Optimize your spatial queries
  • Explain best practices of the usage of spatial operators
  • Explain best practices of the usage of spatial functions
  • Describe how to best define your spatial data model
  • Describe best practices for spatial metadata, tolerance and coordinate systems usage
  • Explain best practices for spatial data loading and validation
  • Describe key spatial application considerations
  • Explain how to optimize Spatial on Exadata
  • Explain how Oracle Spatial is architected to exploit the processing power, bandwidth and parallelism of Exadata
  • Explain how Oracle Spatial on Exadata can ingest massive amounts of data from sensors, weather data, satellites and other streams

Workspace Manager

  • Explain Workspace Manager concepts, features, and architecture
  • Describe the concepts of versioning on a table and create, merge, refresh tables
  • Describe the concepts of administering privileges and locking, and detecting and resolving conflicts
  • Describe some 3rd party GIS tools that use Workspace Manager


Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View (PDF) the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.



 E-mail this page  Printer View