You issued the following statement to monitor the usage of the index： SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）
A: INDEX_STATS
B: DBA_INDEXES
C: DBA_IND_COLUMNS
D: V$OBJECT_USAGE
A: INDEX_STATS
B: DBA_INDEXES
C: DBA_IND_COLUMNS
D: V$OBJECT_USAGE
举一反三
- 假设使用了如下的DDL语句： A: ALTER INDEX sales.customers_id_idx MONITORING USAGE; B: 之后，需要查看以下哪一个数据字典视图以追踪sales用户下的customers_id_idx索引的使用情况A．DBA_INDEXES C: INDEX_STATS D: DBA_OBJECTS E: V$OBJECT_USAGE
- 在下列SQL语句中，( )包含了不正确的定义语句。 Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEX Ⅱ、DROP TABLE DROP VIEW DROP INDEX Ⅲ、ALTER TABLE ALTER VIEW ALTER INDEX A: Ⅰ和Ⅱ B: 只有Ⅱ C: 只有Ⅲ D: Ⅱ和Ⅲ
- 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
- 在SQL中，建立索引的命令是( )。 A: ALTER INDEX B: SET ORDER TO C: SET INDEX TO D: INDEX ON
- 使用（ ）语句可以删除索引 A: modify index B: edit index C: alter index D: drop index