Which feature would enable higher availability during maintenance operations while also improving query response performance?

Which feature would enable higher availability during maintenance operations while also improving
query response performance?

Which feature would enable higher availability during maintenance operations while also improving
query response performance?

A.
Partitioning

B.
Materialized views

C.
Bitmap Indexing

D.
OLAP

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.
Reference: Oracle Database VLDB and Partitioning Guide, 11g Release 1 (11.1), 2 Partitioning
Concepts



Leave a Reply 0

Your email address will not be published. Required fields are marked *