试题详情
多项选择题Which two statements are true about a bitmap index? ()

A、It is recommended for the columns that have unique values.

B、It can be converted to a B-tree index by using the ALTER INDEX command.

C、It has a bitmap segment for each distinct value in the key column, containing a string of bits in which each bit represents the presence or absence of a key column value.

D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

  • C,D
  • 关注下方微信公众号,在线模考后查看

热门试题