Oracle
1Z0-034 · Question #69
While designing a database, you created the EMPLOYEES table as an index-organized table (IOT). You must create a bitmap index on the EMPLOYEES .JOB_ID column. Which must you do to enable the…
The correct answer is B. A mapping table must have been created. See the full explanation below for the reasoning.
Question
While designing a database, you created the EMPLOYEES table as an index-organized table (IOT). You must create a bitmap index on the EMPLOYEES .JOB_ID column. Which must you do to enable the creation of 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
(37 responses)- A14% (5)
- B73% (27)
- C8% (3)
- D5% (2)
Community Discussion
No community discussion yet for this question.