Oracle Database 12c: Multitenancy Essentials — Question 25

Which three are true concerning Storage Indexes?

Answer options

• A. A maximum of eight table columns for any table are indexed per storage region.
• B. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.
• C. Storage Indexes persist across any Exadata storage server reboots.
• D. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
• E. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.
• F. Different storage regions may have different columns indexed for the same table.

Correct answer: A, D, E

Explanation

The correct answers A, D, and E highlight specific characteristics of Storage Indexes, such as their indexing limits, how they can be disabled for a database, and their automatic maintenance by CELLSRV. Options B and C are incorrect as they misrepresent the functionality and persistence of Storage Indexes, while F inaccurately suggests the indexing uniformity across regions.