Click the Exhibit（s） button to view the EMPLOYEES table. The EMPLOYEE table contains thousands of rows. The EMP_CODE column is the primary key column. At the end of every month， you are required to perform search queries based on the BASIC_SAL+COMM column values. Which type of index will you create？（）
A: B-tree Index
B: Bitmap Index
C: Function-based Index
D: Partitioned Index
A: B-tree Index
B: Bitmap Index
C: Function-based Index
D: Partitioned Index
举一反三
- 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？（） A: B-tree B: bitmap C: reverse key D: function based
- 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？（） A: Btree B: bitmap C: reverse key D: function based
- 除了create index命令外，在已有表中创建普通索引的命令是？ A: create table ... add index ... B: update table ... add index ... C: add index ... on table D: alter table ... add index ...
- 在下列SQL语句中，( )包含了不正确的定义语句。 Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEX Ⅱ、DROP TABLE DROP VIEW DROP INDEX Ⅲ、ALTER TABLE ALTER VIEW ALTER INDEX A: Ⅰ和Ⅱ B: 只有Ⅱ C: 只有Ⅲ D: Ⅱ和Ⅲ
- 在SQL中，建立索引的命令是（ ）。 A: CREATE TABLE。 B: CREATE INDEX。 C: CREATE VIEW。 D: INDEX ON。