Oracle Database 12c: Advanced Administration — Question 149

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

Answer options

• A. heap table with a primary key index
• B. external table
• C. hash clustered table
• D. global temporary table
• E. index clustered table

Correct answer: E

Explanation

The index clustered table is the best choice because it organizes the data in a way that improves the efficiency of both updates and read operations, particularly for queries that involve joins. Other options like heap tables or external tables do not provide the same level of performance for hybrid workloads, as they lack the structure needed for fast access and updates.