Oracle 1z1-595 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-595
Exam Name/Title: Oracle Spatial 11g Essentials
Certification Provider: Oracle
Corresponding Certification: Oracle Spatial 11g

Exam Questions: 77
Updated On: Jul 05, 2026

Question #9

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

A. SDO_GEOM.SDO_INTERSECTION(geom1, geom2, .05)

B. SDO_GEOM.SDO_EXCLUDE(geom1, geom2, .05)

C. SDO_GEOM.SDO_UNION(geom1, geom2, .05)

D. SDO_GEOM.SDO_XOR(geom1, geom2, .05)

E. SDO_GEOM.SDO_DIFFERENCE(geom1, geom2, .05)

F. SDO_GEOM.SDO_AGGR_UNION(geom1, geom2, .05)

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #10

Identify the partitioning type that is supported in Oracle Spatial.

A. RANGE

B. COMPOSITE

C. LIST

D. HASH

E. INTERVAL

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #11

There are several ways to create tables for a network. For which two of these techniques would you need to manually fill USER_SDO_NETWORK_METADATA?

A. when you are using a manual definition:CREATE TABLE net_nodes (...);CREATE
TABLE net_links (...);

B. when you are using specific procedures:CALL
SDO_NET.CREATE_NODE_TABLE(...)CALL SDO_NET.CREATE_LINK_TABLE(...)

C. when you are using a specific procedure:CALL SDO_NET.CREATE_NETWORK(...);

D. when you are using a specific procedure:CALL
SDO_NET.CREATE_SDO_NETWORK(...);

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #12

The match mode for a geocoding operation determines how closely the attributes of an input address must match the data stored in the geocoder schema. Which MATCHMODE attribute would you use so that the geocoder can deliver results despite any discrepancies in the input address?

A. RELAX_BASE_NAME

B. RELAX_ALL

C. Null

D. EXACT

E. DEFAULT

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #13

Consider the following procedure:

Which statement explains the result of the preceding procedure?

A. 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.

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. TheSDO_LRS.PROJECT_PTfunction finds the location of a point described by a measure and an offset on a geometric segment.

D. 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.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #14

To be able to create a partitioned index on an SDO_GEOMETRY column in a partitioned table, which statement must be true?

A. The table must contain only point geometries.

B. The table must contain a primary key.

C. The spatial index must beLOCAL.

D. The spatial index must beGLOBAL.

E. The index must be created in parallel.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #15

In the following SQL statement, what is the criteria used for partitioning?

A. MAXVALUE

B. none

C. pXX

D. yellow_pages

E. cell_id

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #16

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. PARTITION

B. EDGE

C. NODE

D. SIGN_POST

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Oracle 1z1-595 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-595 exam.