Oracle Spatial 11g Essentials - 1z1-595 Exam Practice Test

Question 1

The SDO_TOPO_MAP.CREATE_FEATURE function is used to load topologies in Oracle
Spatial. This function generates primitives from geometries, and builds topology objects on the primitives. What does the function return?

A. anSDO_TOPOLOGY_VECTORobject

B. anSDO_TOPO_GEOMETRYobject

C. aVARRAYofNUMBER

D. anST_GEOMETRYobject

E. anSDO_GEOMETRYobject

Correct Answer: B

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

Question 2

You define a theme based on street line features. But you do not want to repeat each street name more than once in your view. What would you do to enable this labeling style?

A. define your theme and associate a text label, with the label function equal to zero (or a negative value)

B. select "Force Labeling" when you define your maps with that theme

C. select "No repetitive label" when you define your maps with that theme

D. define "label minimum scale" and "label maximum scale" when you define your maps with that theme

Correct Answer: C

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

Question 3

Which two statements are true about 3D support in Oracle database?

A. Oracle provides support to point clouds and TIN based on the GDAL open source tool.
This support is available only via the MapViewer.

B. The database provides 3D coordinate systems such as Geographic 3D (long, lat, and ellipsoidal height) and composite systems (based on a two-dimensional system and gravity-related height).

C. Simple solid and composite solid and now stored in a new object calledSDO_PCto allow
3D support within Oracle Spatial database.

D. Oracle has introduced newGTYPEand Element type (ETYPE) values to
extendsdo_geometrycapabilities.

Correct Answer: B,C

Question 4

Which two statements are true about Spatial operators?

A. Both arguments must be in the same coordinate system.

B. They require a spatial index on the first argument.

C. The order of arguments in unimportant.

D. They require a spatial index on both arguments.

E. They can appear only in theWHEREclause.

Correct Answer: B,E

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

Question 5

What is the most efficient, easiest, and fastest mechanism for moving large amounts of
Oracle Spatial data between two databases?

A. home-grown ETL tool

B. transportable tablespaces

C. SQL*Loader

D. DataPump

E. SDO_Loader

Correct Answer: D

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

Question 6

Which three statements are true about the following code?

A. This mapview will center initially at position (-122.45,37.7706), and then zoom at level 4 of the tile cache "demo_map".

B. MVSdoGeometry.createPointwill create a point. This point is used to center the map and will be transformed to the coordinate system of the tile layermvdemo.demo_map.

C. Thethemebasedfoiltheme should be defined as an existing theme by using MapBuilder.

D. Themvdemo.customerstheme will use its own marker image that is defined inuser_sdo_styles.

E. Themvdemo.customerstheme will use "pictures/baseball.gif" to display the customers.

Correct Answer: A,C,E

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

Question 7

Why do you need to use the SDO_WFS_LOCK.registerFeatureTable() operation when publishing a table as a feature class in the Oracle Spatial Web Feature Service (WFS)?

A. It is optional to register the table in the Catalog Service for the Web (CSW) catalog.

B. It is needed only when the table is updated via WFS-T calls.

C. It is needed only when the table is published for read-only access.

D. It is always required when a table is published to WFS.

Correct Answer: D

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

Question 8

In Spatial Analysis and Mining, what does the term binning mean?

A. partitioning data by size

B. simple sort

C. binary searches

D. compressing data

E. classifying data based on location

Correct Answer: E

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

Oracle Spatial 11g Essentials - 1z1-595 Exam Practice Test

Latest Update

Useful Links

Contact Us