Oracle
1Z0-043 · Question #88
While designing your database, you have created the EMPLOYEES table as an index-organized (IOT). You want to create a bitmap index on the JOD_ID column to make queries faster. Which task must have…
The correct answer is B. A mapping table must have been created. See the full explanation below for the reasoning.
Question
While designing your database, you have created the EMPLOYEES table as an index-organized (IOT). You want to create a bitmap index on the JOD_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?
Options
- AA primary key must have been created.
- BA mapping table must have been created.
- CAn overflow tablespace must have been specified.
- DThe PCTTHRESHOLD option must have been specified.
How the community answered
(48 responses)- A17% (8)
- B71% (34)
- C8% (4)
- D4% (2)
Community Discussion
No community discussion yet for this question.