Free Oracle 1z1-595 Exam Dumps Questions & Answers

Which statement is true about the networks managed by the Oracle Spatial Network Data
Model?

• A.  In a directed network, all links can be traversed in both directions.
• B.  A link connects two or more nodes.
• C.  A link can have the same node as start end nodes.
• D.  A node must be connected to at least two links.

Which command will combine two simple overlapping polygons (geom1 and geom2) into a single geometry that excludes the overlapped region?

• A.  SDO_GEOM.SDO_XOR(geom1, geom2, .05)
• B.  SDO_GEOM.SDO_UNION(geom1, geom2, .05)
• C.  SDO_GEOM.SDO_DIFFERENCE(geom1, geom2, .05)
• D.  SDO_GEOM.SDO_EXCLUDE(geom1, geom2, .05)
• E.  SDO_GEOM.SDO_AGGR_UNION(geom1, geom2, .05)
• F.  SDO_GEOM.SDO_INTERSECTION(geom1, geom2, .05)

The Spatial routing engine must have the following tables in its schema: EDGE, NODE, PARTITION, and SIGN_POST. Which table will contain the name and numbers of the highway exists?

• A.  EDGE
• B.  SIGN_POST
• C.  NODE
• D.  PARTITION

Which control file begindata block will successfully add a point geometry to the
CUSTOMERS table when it is used in the following control file:

• A.  1| 2001 -77| 39|
• B.  1| 2001|SDO_POINT_TYPE( -77, 39)|
• C.  1| 2001|SDO_POINT( -77, 39)|
• D.  1| 2001|SDO_POINT ( --77, 39)|
• E.  1| 2001| X| -77| Y| 39|

Consider the following procedure:

Which statement explains the result of the preceding procedure?

• A.  TheSDO_LRS.PROJECT_PTfunction checks whether a measure falls within the measure range of a geometric segment. -1 means that this measure is not part of that segment.
• B.  The perpendicular distance between a segment of the geometry feature and the point (9,3) is 1. A negative offset means that the point is on the right.
• C.  The perpendicular distance between a segment of the geometry feature and the point (9,3) is 1. A negative offset means that the point is on the left.
• D.  TheSDO_LRS.PROJECT_PTfunction finds the location of a point described by a measure and an offset on a geometric segment.