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 appliedto 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