Which two statements are true about a bitmap index? ()

题目
多选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which two statements are true about precedence values in policy?() (Choose two.)

A. 1 is the default precedence.

B. A lower number is preferred.

C. A higher number is preferred.

D. 100 is the default precedence.


参考答案:B, D

第2题:

Examine the following output: SQL> SELECT index_name,status FROM dba_indexes WHERE status=’UNUSABLE’; INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true()

  • A、It is ignored by the query optimizer.
  • B、It is not used while the index is being rebuilt.
  • C、The index cannot be rebuilt, and has to be re-created.
  • D、The index is automatically rebuilt when used the next time

正确答案:A,B

第3题:

Which two statements are true about pool-based source NAT? ()(Choose two.)

A. PAT is not supported.

B. PAT is enabled by default.

C. It supports the address-persistent configuration option.

D. It supports the junos-global configuration option.


参考答案:B, C

第4题:

Which two statements are true regarding B-tree indexs()

  • A、The leaf blocks in the index are doubly linked.
  • B、The leaf node stores a bitmap for each key value.
  • C、The rows with NULL value in key columns also have entries in the index.
  • D、The deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry

正确答案:A,D

第5题:

Which two statements are true about pool-based source NAT? ()(Choose two.)

  • A、PAT is not supported.
  • B、PAT is enabled by default.
  • C、It supports the address-persistent configuration option.
  • D、It supports the junos-global configuration option.

正确答案:B,C

第6题:

Which two statements are true about L2TP tunnels?() (Choose two.)

  • A、Traffic is clear text
  • B、Traffic is encrypted 
  • C、They are initiated by the LNS
  • D、They are initiated by the LAC

正确答案:A,D

第7题:

Which two statements about the Cisco Nexus 1000V VSM are true?()

  • A、It performs switching decisions and forwarding for the VEM
  • B、It can be run on a virtual machine
  • C、It can be used for remote VEM switching Iine cards

正确答案:B,C

第8题:

Which two statements are true about AH?() (Choose two.)

A. AH provides data integrity.

B. AH is identified by IP protocol 50.

C. AH is identified by IP protocol 51.

D. AH cannot work in conjunction with ESP


参考答案:A, C

第9题:

Which two statements are true about precedence values in policy?() (Choose two.)

  • A、1 is the default precedence.
  • B、A lower number is preferred.
  • C、A higher number is preferred.
  • D、100 is the default precedence.

正确答案:B,D

第10题:

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

更多相关问题