File Info
| Exam | Oracle Spatial 11g Essentials |
| Number | 1z0-595 |
| File Name | Oracle.1z0-595.CertDumps.2018-01-06.75q.tqb |
| Size | 2 MB |
| Posted | Jan 06, 2018 |
| Download | Oracle.1z0-595.CertDumps.2018-01-06.75q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
What is the most effective way to compare all the geometries in one layer to all the geometries in another?
- using SDO_CROSS
- using SDO_RELATE
- using SDO_JOIN
- using SDO_LAYER
- using SDO_UNION
Correct answer: B
Explanation:
SDO_RELATE Format: SDO_RELATE(geometry1, geometry2, param);Description Uses the spatial index to identify either the spatial objects that have a particular spatial interaction with a given object such as an area of interest, or pairs of spatial objects that have a particular spatial interaction. This operator performs both primary and secondary filter operations. References: https://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_operat.htm#SPATL1039 SDO_RELATE
Format: SDO_RELATE(geometry1, geometry2, param);
Description
Uses the spatial index to identify either the spatial objects that have a particular spatial interaction with a given object such as an area of interest, or pairs of spatial objects that have a particular spatial interaction.
This operator performs both primary and secondary filter operations.
References: https://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_operat.htm#SPATL1039
Question 2
In the following SQL statement:
What syntax should follow if you want to build each partition’s index later for better manageability?
- DUMMY
- UNUSABLE
- INITIALIZE
- ALL
- CASCADE
Correct answer: B
Explanation:
Create index mdsys.spatial_index local Creating a Local Partitioned Spatial Index If you want to create a local partitioned spatial index, Oracle recommends that you use the procedure in this section instead of using the PARALLEL keyword, to avoid having to start over if the creation of any partition's index fails for any reason (for example, because the tablespace is full). Follow these steps:Create a local spatial index and specify the UNUSABLE keyword. For example:CREATE INDEX sp_idx ON my_table (location) INDEXTYPE IS mdsys.spatial_index PARAMETERS ('tablespace=tb_name work_tablespace=work_tb_name') LOCAL UNUSABLE; This statement executes quickly and creates metadata associated with the index. References: https://docs.oracle.com/database/121/SPATL/creating-local-partitioned-spatial-index.htm Create index mdsys.spatial_index local
Creating a Local Partitioned Spatial Index
If you want to create a local partitioned spatial index, Oracle recommends that you use the procedure in this section instead of using the PARALLEL keyword, to avoid having to start over if the creation of any partition's index fails for any reason (for example, because the tablespace is full). Follow these steps:
Create a local spatial index and specify the UNUSABLE keyword. For example:
CREATE INDEX sp_idx ON my_table (location)
INDEXTYPE IS mdsys.spatial_index
PARAMETERS ('tablespace=tb_name work_tablespace=work_tb_name')
LOCAL UNUSABLE;
This statement executes quickly and creates metadata associated with the index.
References: https://docs.oracle.com/database/121/SPATL/creating-local-partitioned-spatial-index.htm
Question 3
Which statement is true about the networks managed by the Oracle Spatial Network Data Model?
- A link connects two or more nodes.
- In a directed network, all links can be traversed in both directions.
- A link can have the same node as start end nodes.
- A node must be connected to at least two links.
Correct answer: C
Explanation:
Incorrect Answers:A: A link represents a relationship between two nodes.B: Within a directed network, any link can be undirected (that is, able to be traversed either from the start node to the end node or from the end node to the start node) or directed (that is, able to be traversed only from the start node to the end node). Within an undirected network, all links are undirected.D: An isolated node is a node that is not included in any links.References: https://docs.oracle.com/cd/B28359_01/appdev.111/b28399/sdo_net_concepts.htm#CIHFIHFB Incorrect Answers:
A: A link represents a relationship between two nodes.
B: Within a directed network, any link can be undirected (that is, able to be traversed either from the start node to the end node or from the end node to the start node) or directed (that is, able to be traversed only from the start node to the end node). Within an undirected network, all links are undirected.
D: An isolated node is a node that is not included in any links.
References: https://docs.oracle.com/cd/B28359_01/appdev.111/b28399/sdo_net_concepts.htm#CIHFIHFB
