Online Access Free 1z1-595 Exam Questions

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

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

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.row-level security
• B.triggers
• C.index-organized tables
• D.DataVault
• E.partitioning

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

• A.Simple solid and composite solid and now stored in a new object calledSDO_PCto allow
  3D support within Oracle Spatial database.
• 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.Oracle has introduced newGTYPEand Element type (ETYPE) values to
  extendsdo_geometrycapabilities.
• D.Oracle provides support to point clouds and TIN based on the GDAL open source tool.
  This support is available only via the MapViewer.

In the following SQL statement, what is the criteria used for partitioning?

• A.pXX
• B.none
• C.yellow_pages
• D.cell_id
• E.MAXVALUE

Which control file begindata block will successfully add a point geometry to the
CUSTOMERS table when it is used in the following control file:

• A.1| 2001|SDO_POINT_TYPE( -77, 39)|
• B.1| 2001|SDO_POINT ( --77, 39)|
• C.1| 2001| X| -77| Y| 39|
• D.1| 2001 -77| 39|
• E.1| 2001|SDO_POINT( -77, 39)|