Oracle
1Z0-043 · Question #123
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: (a) high availability of data (b) faster primary key access to the…
The correct answer is D. index-organized tables (IOTs). See the full explanation below for the reasoning.
Question
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:
(a) high availability of data (b) faster primary key access to the table data (c) compact storage for the table Which type of tables would you use to achieve these objectives?
Options
- Aheap tables
- Bobject tables
- Cpartitioned tables
- Dindex-organized tables (IOTs)
How the community answered
(39 responses)- A13% (5)
- B8% (3)
- C3% (1)
- D77% (30)
Community Discussion
No community discussion yet for this question.