1Z0-515 · Question #46
Which feature would enable higher availability during maintenance operations while also improving query response performance?
The correct answer is A. Partitioning. Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller p
Question
Which feature would enable higher availability during maintenance operations while also improving query response performance?
Options
- APartitioning
- BMaterialized views
- CBitmap Indexing
- DOLAP
How the community answered
(26 responses)- A73% (19)
- B15% (4)
- C8% (2)
- D4% (1)
Explanation
Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Oracle provides a rich variety of partitioning strategies and extensions to address every business requirement. Moreover, since it is entirely transparent, partitioning can be applied to almost any application without the need for potentially expensive and time consuming application changes.
Topics
Community Discussion
No community discussion yet for this question.