Which task must have been completed so that you are able to create the bitmap index?

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?

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?

A.
A primary key must have been created.

B.
A mapping table must have been created.

C.
An overflow tablespace must have been specified.

D.
The PCTTHRESHOLD option must have been specified.



Leave a Reply 0

Your email address will not be published. Required fields are marked *