Free Oracle 1z0-595 Exam Dumps Questions & Answers

Which SQL statement will insert a valid rectangular geometry into the SALES_AREA table that has a geometry column called GEOM using SRID 8307 (WGS84)?

• A.  Option E
• B.  Option A
• C.  Option D
• D.  Option B
• E.  Option C

Which three statements are true about what is included in the CS_SRS table?

• A.  It contains minimum and maximum values for each axis of a specified layer.
• B.  It contains the SRID as a unique identifier to link geometries with the coordinate system.
• C.  It contains supported coordinate systems based on the standard EPSG data model.
• D.  It contains a list of coordinate systems to allow creation of indexed layers that have multiple SRIDs within the same layer.
• E.  It contains the coordinate system definitions.

What is the value of the return_driving_directions parameter, to obtain the following response from the Oracle Spatial Route Server?

• A.  TRUE
• B.  NO
• C.  YES
• D.  Null
• E.  FALSE

Which two spatial predicates return all the cities that are located in a given county?

• A.  SDO_CONTAINS (city_geom, county_geom) = 'TRUE'
• B.  SDO_ANYINTERACT (city_geom, county_geom) = 'TRUE'
• C.  SDO_ANYINTERACT (county_geom, city_geom) = 'TRUE'
• D.  SDO_INSIDE (county_geom, city_geom) = 'TRUE'

MapViewer uses many parameters to configure its behavior. Identify two ways to specify those parameters.

• A.  using environment variables
• B.  via a web configuration console
• C.  by having the end user dynamically set them
• D.  by editing a configuration file