File Info
| Exam | Oracle Spatial 11g Essentials |
| Number | 1z0-595 |
| File Name | Oracle.1z0-595.PracticeTest.2017-12-14.39q.tqb |
| Size | 928 KB |
| Posted | Dec 14, 2017 |
| Download | Oracle.1z0-595.PracticeTest.2017-12-14.39q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
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_AREAFormatSDO_GEOM.SDO_AREA( geom IN SDO_GEOMETRY, dim IN SDO_DIM_ARRAY [, unit IN VARCHAR2] ) RETURN NUMBER;orSDO_GEOM.SDO_AREA( geom IN SDO_GEOMETRY, tol IN NUMBER [, unit IN VARCHAR2] ) RETURN NUMBER;DescriptionReturns the area of a two-dimensional polygon.ParametersgeomGeometry object.dimDimensional information array corresponding to geom, usually selected from one of the xxx_SDO_GEOM_METADATA views.unitUnit 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.tolTolerance valueReferences: 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
Question 2
You have defined a number of Web Map Service (WMS) and Web Feature Service (WFS) themes by using the MapBuilder tool of Oracle MapViewer. Which two actions can you perform with those themes?
- Overlay a WMS theme with the data from your database.
- Overlay a WMS theme with the data from a WFS theme.
- Perform SQL searches on the WFS themes.
- Reproject the WFS geometries to a different coordinate system.
- Copy data from a WFS theme into your database.
Correct answer: AD
Explanation:
A: Regardless of what type of data is associated with a theme (except for WMS themes, which represent externally rendered map layers), the MapViewer styling rules still need to be defined for each theme, and the styles referenced by the styling rules must exist and be stored in the database as part of the mapping metadata.D: A WFS theme is a special kind of MapViewer theme that supports the rendering of data delivered using the Open GIS Consortium (OGC) Web Feature Service (WFS) protocol, specifically the WFS 1.0.0 implementation specification.WFS theme are conceptually similar to geometry themes, and users are able to render and label features. The WFS operations GetCapabilities, DescribeFeatureType, and GetFeature are used when rendering a WFS theme. When a WFS service is accessed, MapViewer caches the information about capabilities and feature types. References: https://docs.oracle.com/cd/E12839_01/web.1111/e10145/vis_concepts.htm#JIMPV9548 A: Regardless of what type of data is associated with a theme (except for WMS themes, which represent externally rendered map layers), the MapViewer styling rules still need to be defined for each theme, and the styles referenced by the styling rules must exist and be stored in the database as part of the mapping metadata.
D: A WFS theme is a special kind of MapViewer theme that supports the rendering of data delivered using the Open GIS Consortium (OGC) Web Feature Service (WFS) protocol, specifically the WFS 1.0.0 implementation specification.
WFS theme are conceptually similar to geometry themes, and users are able to render and label features. The WFS operations GetCapabilities, DescribeFeatureType, and GetFeature are used when rendering a WFS theme. When a WFS service is accessed, MapViewer caches the information about capabilities and feature types.
References: https://docs.oracle.com/cd/E12839_01/web.1111/e10145/vis_concepts.htm#JIMPV9548
Question 3
Identify four OGC vector data formats that Oracle Spatial can translate to and from natively.
- GML
- SHP
- WKT
- WKB
- GWT
- KML
Correct answer: ACDF
Explanation:
Oracle Spatial provides different types of converters to convert the geometry data to GML (both Version 2.1 and Version 3.1.1), KML, and the well-known text and binary (WKT and WKB) representations. These converters are provided as PL/SQL functions and Java APIs. References: https://www.safaribooksonline.com/library/view/applying-and-extending/9781849686365/ch02s07.htmlhttps://docs.oracle.com/database/121/SPATL/sdo_util-from_wktgeometry.htmhttps://docs.oracle.com/database/121/SPATL/sdo_util-to_wkbgeometry.htm#SPATL1250 Oracle Spatial provides different types of converters to convert the geometry data to GML (both Version 2.1 and Version 3.1.1), KML, and the well-known text and binary (WKT and WKB) representations. These converters are provided as PL/SQL functions and Java APIs.
References: https://www.safaribooksonline.com/library/view/applying-and-extending/9781849686365/ch02s07.html
https://docs.oracle.com/database/121/SPATL/sdo_util-from_wktgeometry.htm
https://docs.oracle.com/database/121/SPATL/sdo_util-to_wkbgeometry.htm#SPATL1250
