exam questions

Exam 1z0-595 All Questions

View all questions & answers for the 1z0-595 exam

Exam 1z0-595 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-595
Question #: 34
Topic #: 1
[All 1z0-595 Questions]

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. index-organized tables
  • B. partitioning
  • C. triggers
  • D. row-level security
  • E. DataVault
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Partitioning is an Oracle Database feature in which a single table is decomposed into multiple smaller tables called partitions. Queries do not have to be modified in any way to use partitioning. DDL operations such as rebuilding indexes can be done against single partitions in the logical table structure rather than the whole table as a monolithic entity. This enhances the manageability of data by dividing large tasks into small tasks, and allowing for recovery should a problem occur during these DDL operations.
References:
http://download.oracle.com/otndocs/products/spatial/pdf/spatial_wp10_bestprac.pdf
, page 2

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...