Online Access Free 1z0-595 Exam Questions

Identify the partitioning type that is supported in Oracle Spatial.

• A.LIST
• B.INTERVAL
• C.RANGE
• D.HASH
• E.COMPOSITE

Which two statements are true about Spatial operators?

• A.They require a spatial index on both arguments.
• B.They require a spatial index on the first argument.
• C.The order of arguments in unimportant.
• D.Both arguments must be in the same coordinate system.
• E.They can appear only in theWHEREclause.

Which two are benefits of partitioning in Oracle Spatial?

• A.reduced CPU utilization
• B.reduced network utilization
• C.reduced storage needs
• D.faster index builds
• E.query parallelism

Which function call would return the area of a geometry, geom1, in square kilometers?

• A.SDO_GEOM.SDO_AREA(geom1, 'unit=SQ_KM')
• B.SDO_GEOM.SDO_AREA(geom1, .05)
• C.SDO_GEOM.SDO_AREA_SQ_KM(geom1)
• D.SDO_GEOM.SDO_AREA(geom1, .05, 'unit=SQ_KM')
• E.SDO_GEOM.SDO_AREA_SQ_KM(geom1, .05)

The MapViewer administration console can be used to define a dynamic database connection (data source).
Which two options indicate how long this data source is preserved?

• A.forever
• B.until the user logs out
• C.until the application server is shut down
• D.until MapViewer restarts