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
正确答案
答案解析
相似试题
(多选题)
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?()