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. 5)

  • 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 #21
What is the following query best suited for?

  1. A
    listing partitions by size
  2. B
    visualizing the partitions
  3. C
    clustering the partitions
  4. D
    virtualizing the partitions
  5. E
    normalizing the data

Correct Answer:
B
Sdo_aggr_mbr returns the minimum bounding rectangle (MBR) of the specified geometries, that is, a single rectangle that minimally encloses the geometries.
References:
https://docs.oracle.com/database/121/SPATL/sdo_aggr_mbr.htm

Question #22
To refresh workspace E1 you use the command DBMS_WM.RefreshWorkspace(E1);
What is the impact of that command? Identify the two correct answers.
  1. A
    It applies all the changes made in the child to the parent because the child was created or refreshed last.
  2. B
    When a workspace or table is refreshed, all conflicts are automatically resolved.
  3. C
    When a workspace or table is refreshed, all conflicts must be resolved.
  4. D
    It applies all the changes made in the parent to the child because the child was created or refreshed last.

Correct Answer:
CD
RefreshWorkspace applies to a workspace all changes made in its parent workspace.
This procedure applies to workspace all changes made to version-enabled tables in the parent workspace since the time when workspace was created or last refreshed.
If there are conflicts between the workspace being refreshed and its parent workspace, the refresh operation fails and the user must manually resolve conflicts using the <table_name>_CONF view.
References:
https://docs.oracle.com/cd/E16338_01/appdev.112/e11826/long_ref.htm#ADWSM99355

Question #23
Oracle Spatial expects the ring of a polygon boundary to be oriented ______.
  1. A
    clockwise
  2. B
    counterclockwise
  3. C
    true north
  4. D
    grid north
  5. E
    low to high elevation

Correct Answer:
to _____?B
Oracle Spatial expects the ring of the polygon boundary to be oriented counterclockwise.
References: Pro Oracle Spatial for Oracle Database 11g (3 Jan 2012), page 664

Question #24
Always store two or three dimensional point data in SDO_POINT. To ensure less storage and faster query access to such point data, set SDO_ELEM_INFO and

SDO_ORDINATES -
  1. A
    SDO_GEOMETRY
  2. B
    SDO_FAST
  3. C
    NULL
  4. D
    NUM_DIMENSIONS
  5. E
    SDO_POINT

Correct Answer:
C
The SDO_POINT attribute is defined using the SDO_POINT_TYPE object type, which has the attributes X, Y, and Z, all of type NUMBER. If the
SDO_ELEM_INFO and SDO_ORDINATES arrays are both null, and the SDO_POINT attribute is non-null, then the X, Y, and Z values are considered to be the coordinates for a point geometry. Otherwise, the SDO_POINT attribute is ignored by Spatial.
References:
https://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_objrelschema.htm

Question #25
The Spatial routing engine must have the following tables in its schema: EDGE, NODE, PARTITION, and SIGN_POST. Which table will contain the name and numbers of the highway exists?
  1. A
    EDGE
  2. B
    NODE
  3. C
    PARTITION
  4. D
    SIGN_POST

Correct Answer:
D
The SIGN_POST table stores sign information that is used to generate driving directions. For example, a sign might indicate that Exit 33A on US Route 3 South goes toward Winchester. A SIGN_POST row might correspond to a physical sign at an exit ramp on a highway, but it does not need to correspond to a physical sign.
References:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_route_server.htm#SPATL904

Previous Questions Next Questions

All Pages