單項選擇題

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

A.ALTER TABLE employees monitor index employee_idx_fk;
B.ALTER INDEX employee_idx_fk monitoring on;
C.ALTER TABLE employees monitor all indexes;
D.ALTER INDEX employee_idx_fk monitoring usage;

你可能感興趣的試題

多項選擇題

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）

A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

單項選擇題

When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）

A.During a query’s parse time only.
B.During a query’s execution time only.
C.During any kind of DML statement execution.
D.During the execution of an INSERT statement only.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

你可能感興趣的試題

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）

When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）

When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）