Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-595

Oracle 1z0-595 Exam Practice Questions (P. 4)

  • Full Access (75 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
What does Oracle Spatial use to generate the R-tree spatial index entry for a polygon geometry?
  1. A
    the perimeter of the geometry
  2. B
    the minimum bounding rectangle of the geometry
  3. C
    the number of ordinates in the geometry
  4. D
    the area of the geometry
  5. E
    SDO_GTYPE of the geometry

Correct Answer:
B
A spatial R-tree index can index spatial data of up to four dimensions. An R-tree index approximates each geometry by a single rectangle that minimally encloses the geometry (called the minimum bounding rectangle, or MBR), as shown in figure below.

For a layer of geometries, an R-tree index consists of a hierarchical index on the MBRs of the geometries in the layer, as shown in the figure below.

1 through 9 are geometries in a layer.
a, b, c, and d are the leaf nodes of the R-tree index, and contain minimum bounding rectangles of geometries, along with pointers to the geometries. For example, a contains the MBR of geometries 1 and 2, b contains the MBR of geometries 3 and 4, and so on.
A contains the MBR of a and b, and B contains the MBR of c and d.
The root contains the MBR of A and B (that is, the entire area shown).
References:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_intro.htm#SPATL459

Question #17
Which command will load a shapefile named states.shp by using the GDAL/ORG command-line utilities? Assume that the database name, username, and password are mvdemo.
  1. A
    gdal_translate –of oracle mvdemo/mvdemo@mvdemo states.shp
  2. B
    ogr2ogr –f OCI:mvdemo/mvdemo@mvdemo states.shp
  3. C
    ogr2oracle –f OCI mvdemo/mvdemo@mvdemo states.shp
  4. D
    ogr2oracle –f ORACLE mvdemo/mvdemo@mvdemo states.shp
  5. E
    gdal_translate –of OCI mvdemo/mvdemo@mvdemo states.shp

Correct Answer:
B
Example -
Simple translation of a shapefile into Oracle. The table 'ABC' will be created with the features from abc.shp and attributes from abc.dbf.
% ogr2ogr -f OCI OCI:warmerda/[email protected] abc.shp
References:
http://www.gdal.org/drv_oci.html

Question #18
Which two are benefits of partitioning in Oracle Spatial?
  1. A
    reduced CPU utilization
  2. B
    reduced network utilization
  3. C
    query parallelism
  4. D
    faster index builds
  5. E
    reduced storage needs

Correct Answer:
CD
Partitioning is used in data management solutions to address issues of manageability, scalability, and performance
C: Here are some Oracle partitioning capabilities that can enhance scalability and performance:
✑ Search multiple table or index partitions in parallel
✑ Spread the I/O load associated with table or index accesses across multiple controllers
✑ Store data physically on disk so that data that is likely to be processed together is close together on disk
✑ Eliminate partitions from consideration based on a partition key
D: There are many meaningful benefits of partitioning to enhance manageability in a DBMS solution.
These benefits include the ability to:
✑ Backup data on a partition-by-partition basis
✑ Restore data on a partition-by-partition basis
✑ Load a partition at a time
✑ Store data in different tablespaces on a partition-by-partition basis
✑ Rebuild indexes on a partition-by-partition basis
References: http://download.oracle.com/otndocs/products/spatial/pdf/spatial_wp10_bestprac.pdf, page 4

Question #19
Identify two compression types that are not natively supported by GeoRaster, but are supported through the Lizardtech GeoRaster plugin.
  1. A
    BMP
  2. B
    MrSID
  3. C
    JPEG 2000
  4. D
    ECW
  5. E
    TIFF
  6. F
    JPEG

Correct Answer:
BC
Oracle Spatial GeoRaster 10g Release 2 provides a plugin architecture to support wavelet compression schemes such as those from LizardTech. Users who install the LizardTech plugin may compress GeoRaster objects using any of three wavelet compression types:
MrSID Generation 2, MrSID Generation 3 and LizardTech JPEG 2000.
References:
http://doc.lizardtech.com/uploads/2012/02/georaster-lizardtech-mrsid-129598.pdf

Question #20
In Spatial Analysis and Mining, what does the term binning mean?
  1. A
    binary searches
  2. B
    partitioning data by size
  3. C
    compressing data
  4. D
    simple sort
  5. E
    classifying data based on location

Correct Answer:
E
The spatial analysis and mining features in Oracle Spatial let you exploit spatial correlation by using the location attributes of data items in several ways: for binning (discretizing) data into regions (such as categorizing data into northern, southern, eastern, and western regions), for materializing the influence of neighborhood (such as number of customers within a two-mile radius of each store), and for identifying colocated data items (such as video rental stores and pizza restaurants).
References:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_sam_concepts.htm#SPATL070

Previous Questions Next Questions

All Pages