View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the…

Bitmap indexes are designed for columns with low cardinality (few distinct values like zone names), large tables, and rare DML operations. In a DSS environment where queries scan large portions of the table and updates are infrequent, bitmap indexes provide superior query performance because Oracle can perform fast bitwise AND/OR operations across zone bitmaps instead of traversing a BTree structure.

A reverse key index is used to redistribute sequential inserts across index blocks to reduce contention in high-concurrency OLTP or RAC environments, not to optimize read queries on low-cardinality columns.

A normal BTree index performs best on high-cardinality columns where queries return a small percentage of rows; it is inefficient for low-cardinality columns like ZONE because it does not compress repetitive values.

A function-based index is used when queries apply a SQL function or expression to the indexed column in the WHERE clause; no such function is described in this scenario.