Oracle 1z0-595 問題集

質問 1：
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 A
B. Option C
C. Option D
D. Option B
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
When working with bounds and tolerance for geodetic data, always specify the tolerance for all dimensions to be set in _______.
A. feet
B. meters
C. miles
D. degrees
E. percentage of results
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
In the following SQL statement:

What syntax should follow if you want to build each partition's index later for better manageability?
A. INITIALIZE
B. ALL
C. UNUSABLE
D. DUMMY
E. CASCADE
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 specific procedure:CALL
SDO_NET.CREATE_SDO_NETWORK(...);
B. when you are using a manual definition:CREATE TABLE net_nodes (...);CREATE
TABLE net_links (...);
C. when you are using a specific procedure:CALL SDO_NET.CREATE_NETWORK(...);
D. when you are using specific procedures:CALL
SDO_NET.CREATE_NODE_TABLE(...)CALL SDO_NET.CREATE_LINK_TABLE(...)
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Identify three metadata tables that are used to find information about the spatial indexes in a schema.
A. user_sdo_indexes
B. user_indexes
C. user_sdo_index_metadata
D. user_sdo_columns
E. user_sdo_geom_metadata
F. user_sdo_index_info
正解：C,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. EXACT
B. RELAX_ALL
C. Null
D. RELAX_BASE_NAME
E. DEFAULT
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
How is the outer ring rotation defined?
A. does not matter
B. depending on the type of polygons
C. counterclockwise
D. clockwise
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
In the following SQL statement, why is the DETERMINISTIC parameter important?

A. it trims the results set
B. it is required by function-based indexes
C. it enables parallelism
D. it enables a higher level of row-based security
E. it greatly reduces storage allocation
正解：B
解説: (Topexam メンバーにのみ表示されます)