Oracle
1Z0-043 · Question #130
In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application…
The correct answer is A. Heap table. See the full explanation below for the reasoning.
Question
In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance?
Options
- AHeap table
- BObject table
- CExternal table
- DClustered table
- EGlobal temporary table
- FIndex-organized table (IOT)
How the community answered
(48 responses)- A83% (40)
- B4% (2)
- C2% (1)
- D8% (4)
- E2% (1)
Community Discussion
No community discussion yet for this question.