1z1-595 Exam Training Practice Tests (Oracle Spatial 11g Essentials)]

Question 1

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

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

Correct Answer: C,D,E

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

Question 2

To refresh workspace E1 you use the command DBMS_WM.RefreshWorkspace('E1');
What is the impact of that command? Identify the two correct answers.

A. It applies all the changes made in the child to the parent because the child was created or refreshed last. B. It applies all the changes made in the parent to the child because the child was created or refreshed last. C. When a workspace or table is refreshed, all conflicts must be resolved. D. When a workspace or table is refreshed, all conflicts are automatically resolved.

Correct Answer: B,C

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

Question 3

Which statement describes the way network partitions are used?

A. When the network application starts, partitions are loaded into the partition cache until the cache is filled. B. Partitions are always loaded from the partition BLOBs. C. Partitions are loaded to solve a network search, and then they are freed immediately. D. Partitions are loaded as needed to solve a network search and retained until the space they occupy is needed by other partitions.

Correct Answer: B

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

Question 4

Consider that you have two tables: one contains the locations of all antennas from a mobile telephone operator and the other contains the locations of all schools. Identify the query that will find all cases where an antenna is less than 50 meters from a primary school.

A. Option D B. Option B C. Option A D. Option C

Correct Answer: C

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

Question 5

Identify two kinds of information that can be stored in an SDO_GEORASTER object.

A. any changes detected in a raster object B. the name of the raster's RDT (raster data table) C. raster cell data D. the spatial extent of a raster object E. the blocks of a raster object

Correct Answer: C,D

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

Question 6

Oracle Spatial does not have specific recommendations or restrictions for how an application should be organized. However, if you have large amounts of Spatial data, the one database feature that you should use is ______.

A. triggers B. DataVault C. partitioning D. index-organized tables E. row-level security

Correct Answer: C

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

Question 7

How is the outer ring rotation defined?

A. does not matter B. counterclockwise C. clockwise D. depending on the type of polygons

Correct Answer: B

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

Question 8

What is the most effective way to compare all the geometries in one layer to all the geometries in another?

A. usingSDO_JOIN B. usingSDO_UNION C. usingSDO_LAYER D. usingSDO_CROSS E. usingSDO_RELATE

Correct Answer: E

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

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