Oracle 1z0-595 Exam Practice Questions (P. 3)
- Full Access (75 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #11
Which technique will allow multiple georaster objects to be loaded simultaneously when you use GDAL?
- Ausing the –multi command-line parameter of gdalwarp
- Busing the –scale command-line parameter of gdal_translate
- Ccreating multiple raster data tables and using the –multi command-line parameter of gdalwarp
- Dbuilding a process that creates multiple threads that run gdal_translate
Correct Answer:
A
Use the -multi option with gdalwarp to enable multithreading, as opposed to only multiple cores.
References:
https://trac.osgeo.org/gdal/changeset/38196
A
Use the -multi option with gdalwarp to enable multithreading, as opposed to only multiple cores.
References:
https://trac.osgeo.org/gdal/changeset/38196
send
light_mode
delete
Question #12
Which function call would return the area of a geometry, geom1, in square kilometers?
- ASDO_GEOM.SDO_AREA(geom1, .05)
- BSDO_GEOM.SDO_AREA(geom1, .05, ‘unit=SQ_KM’)
- CSDO_GEOM.SDO_AREA(geom1, ‘unit=SQ_KM’)
- DSDO_GEOM.SDO_AREA_SQ_KM(geom1, .05)
- ESDO_GEOM.SDO_AREA_SQ_KM(geom1)
Correct Answer:
B
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 -
References:
https://docs.oracle.com/database/121/SPATL/sdo_geom-sdo_area.htm#SPATL1110
B
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 -
References:
https://docs.oracle.com/database/121/SPATL/sdo_geom-sdo_area.htm#SPATL1110
send
light_mode
delete
Question #13
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?
- AOverlay a WMS theme with the data from your database.
- BOverlay a WMS theme with the data from a WFS theme.
- CPerform SQL searches on the WFS themes.
- DReproject the WFS geometries to a different coordinate system.
- ECopy data from a WFS theme into your database.
Correct Answer:
AD
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
AD
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
send
light_mode
delete
Question #14
Identify four OGC vector data formats that Oracle Spatial can translate to and from natively.
- AGML
- BSHP
- CWKT
- DWKB
- EGWT
- FKML
Correct Answer:
ACDF
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
ACDF
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
send
light_mode
delete
Question #15
Which two requests will you use to update records in a catalog that is published via the Catalog Service for the Web (CSW)?
- AGetRecords
- BGetRecordsWithLock
- CTransaction
- DHarvest
Correct Answer:
CD
Operations defined by the CSW standard include:
Transaction (optional): create/edit metadata by 'pushing' the metadata to the server
Harvest (optional): create/update metadata by asking the server to 'pull' metadata from somewhere
GetCapabilities: "allows CSW clients to retrieve service metadata from a server"
DescribeRecord: "allows a client to discover elements of the information model supported by the target catalogue service. The operation allows some or all of the information model to be described".
GetRecords: search for records, returning record IDs
GetRecordById: "retrieves the default representation of catalogue records using their identifier"
GetDomain (optional): "used to obtain runtime information about the range of values of a metadata record element or request parameter"
Note: Catalog Service for the Web (CSW), sometimes seen as Catalog Service - Web, is a standard for exposing a catalogue of geospatial records in XML on the
Internet (over HTTP). The catalogue is made up of records that describe geospatial data (e.g. KML), geospatial services (e.g. WMS), and related resources.
References:
https://en.wikipedia.org/wiki/Catalog_Service_for_the_Web
CD
Operations defined by the CSW standard include:
Transaction (optional): create/edit metadata by 'pushing' the metadata to the server
Harvest (optional): create/update metadata by asking the server to 'pull' metadata from somewhere
GetCapabilities: "allows CSW clients to retrieve service metadata from a server"
DescribeRecord: "allows a client to discover elements of the information model supported by the target catalogue service. The operation allows some or all of the information model to be described".
GetRecords: search for records, returning record IDs
GetRecordById: "retrieves the default representation of catalogue records using their identifier"
GetDomain (optional): "used to obtain runtime information about the range of values of a metadata record element or request parameter"
Note: Catalog Service for the Web (CSW), sometimes seen as Catalog Service - Web, is a standard for exposing a catalogue of geospatial records in XML on the
Internet (over HTTP). The catalogue is made up of records that describe geospatial data (e.g. KML), geospatial services (e.g. WMS), and related resources.
References:
https://en.wikipedia.org/wiki/Catalog_Service_for_the_Web
send
light_mode
delete
All Pages