Oracle 1Z0-595 Certification Exam Syllabus

1Z0-595 Syllabus, 1Z0-595 Dumps PDF, Oracle OCS Dumps, 1Z0-595 Dumps Free Download PDF, Oracle Spatial 11g R2 OCS Dumps, 1Z0-595 Latest Dumps Free DownloadYou can use this exam guide to collect all the information about Oracle Spatial 11g Essentials (1Z0-595) certification. The Oracle 1Z0-595 certification is mainly targeted to those candidates who has some experience or exposure of Oracle Spatial 11g R2 and want to flourish their career with Oracle Spatial 11g Certified Implementation Specialist (OCS) credential. The Oracle Spatial 11g Essentials certification exam validates your understanding of the Oracle Spatial 11g R2 technology and sets the stage for your future progression. Your preparation plan for Oracle 1Z0-595 Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following Certification Exam Topics table.

Oracle 1Z0-595 Certification Details:

Exam Name Oracle Spatial 11g Essentials
Exam Code 1Z0-595
Exam Product Version Oracle Spatial 11g R2
Exam Price USD $245 (Pricing may vary by country or by localized currency)
Duration 120
Number of Questions 76
Passing Score 62
Format Multiple Choice
Recommended Training Oracle Spatial: Essentials
Schedule Exam Pearson VUE - Oracle
Recommended Practice 1Z0-595 Online Practice Exam

Oracle 1Z0-595 Certification 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
- 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
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
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
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
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

The Oracle 1Z0-595 Certification Program certifies candidates on skills and knowledge related to Oracle Spatial 11g R2 products and technologies. The Oracle Spatial 11g Certified Implementation Specialist is granted based on a combination of passing exams, training and performance-based assignments, depending on the level of certification. Oracle 1Z0-595 certification is tangible benchmark of experience and expertise that help you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exam and hands-on experience to prepare for your Oracle Spatial 11g Essentials certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.

Rating: 4.9 / 5 (40 votes)