单选题

The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()

AB-tree

Bbitmap

Creverse key

Dfunction based

正确答案

来源:www.examk.com

答案解析

相似试题
  • The NLS_SORT parameter sets the default sort method for which of the following operations?()

    多选题查看答案

  • Which two statements are true about the duplexing of the backups taken by RMAN?()  

    多选题查看答案

  • Which of the following are valid program types for a lightweight job?()

    多选题查看答案

  • Which of the following files can be used to configure connection pooling in the shared server environment?()

    单选题查看答案

  • Which four occur during the processing of a request using Oracle Shared Server?()

    多选题查看答案

  • Which  statements are true regarding the Oracle Data Pump export and import operations()

    多选题查看答案

  • You want the size of the tablespace to increase when it is full. Which option would you use?()

    单选题查看答案

  • Which two statements are true regarding the USING and ON clauses in table joins?()

    多选题查看答案

  • Which background process reads the redo log buffer and writes it to a file?()

    单选题查看答案