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 indexorganized (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 indexorganized (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 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 *