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

While designing your database, you have created the EMPLOYEEStable as an index-organized
(IOT). You want to create a bitmap index on the JOD_IDcolumn 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 EMPLOYEEStable as an index-organized
(IOT). You want to create a bitmap index on the JOD_IDcolumn 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 overflowtablespace 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 *