Exam Title: Oracle Spatial 11g Essentials
Exam Number: 1Z0-595
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 76
Passing Score: 62%
Validated Against: This exam has been validated against 11gR2.
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
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 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
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
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
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
GeoRaster
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
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
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
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
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
Define and manage tile caches
Build applications using the Oracle Maps tutorial
Integrate external data
Define and access OGC Web Mapping Service and Web Feature Services
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
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
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
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
QUESTION 1
Why do you need to use the SDO_WFS_LOCK.registerFeatureTable() operation when publishing a table as a feature
class in the Oracle Spatial Web Feature Service (WFS)?
A. It is always required when a table is published to WFS.
B. It is needed only when the table is published for read-only access.
C. It is needed only when the table is updated via WFS-T calls.
D. It is optional to register the table in the Catalog Service for the Web (CSW) catalog.
Answer: A
Explanation:
SDO_WFS_LOCK.registerFeatureTableregisters a feature table; that is, enables the feature table for WFS transaction
locking. This procedure ensures that the necessary constraints for implementing WFS transaction semantics are
associated with the feature table.
References:https://docs.oracle.com/database/121/SPATL/sdo_wfs_lock-registerfeaturetable.htm#SPATL1255
QUESTION 2
Which two statements are true about Spatial operators2
A. They require a spatial index on both arguments.
B. They require a spatial index on the first argument.
C. Both arguments must be in the same coordinate system.
D. They can appear only in theWHEREclause.
E. The order of arguments in unimportant.
Answer: B,D
Explanation:
Example: SDO_NN(geometry1, geometry2, param [, number]);
Uses the spatial index to identify the nearest neighbors for a geometry. Parameters include:
The operator must always be used in a WHERE clause.
References:https://docs.oracle.com/cd/A97630_01/appdev.920/a96630/sdo_operat.htm#i7 8531
QUESTION 3
How is the outer ring rotation defined?
A. counterclockwise
B. clockwise
C. does not matter
D. depending on the type of polygons
Answer: A
Explanation:
Outer ringsshould be counterclockwise, inner rings clockwise.
References:https://download.oracle.com/otndocs/products/spatial/pdf/spatial_wp09_bestpra c.pdf(page 6)
QUESTION 4
Oracle Spatial expects the ring of a polygon boundary to be oriented ______.
A. clockwise
B. counterclockwise
C. true north
D. grid north
E. low to high elevation
Answer: B
Explanation:
Oracle Spatial expects the ring of the polygon boundaryto be oriented counterclockwise.
References: Pro Oracle Spatial for Oracle Database 11g (3 Jan 2012), page 664
QUESTION 5
Which function call would return the area of a geometry, geom1, in square kilometers?
A. SDO_GEOM.SDO_AREA(geom1, .05)
B. SDO_GEOM.SDO_AREA(geom1, .05, ‘unit=SQ_KM’)
C. SDO_GEOM.SDO_AREA(geom1, ‘unit=SQ_KM’)
D. SDO_GEOM.SDO_AREA_SQ_KM(geom1, .05)
E. SDO_GEOM.SDO_AREA_SQ_KM(geom1)
Answer: B
