Oracle
1Z0-063 · Question #160
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…
The correct answer is E. index clustered table. See the full explanation below for the reasoning.
Question
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?
Options
- Aheap table with a primary key index
- Bexternal table
- Chash clustered table
- Dglobal temporary table
- Eindex clustered table
How the community answered
(32 responses)- A16% (5)
- B3% (1)
- C3% (1)
- D6% (2)
- E72% (23)
Community Discussion
No community discussion yet for this question.