（单选题）
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？（）
AALTER TABLE employees monitor index employee_idx_fk;
BALTER INDEX employee_idx_fk monitoring on;
CALTER TABLE employees monitor all indexes;
DALTER INDEX employee_idx_fk monitoring usage;
正确答案
答案解析
略
相似试题
（单选题）
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
（单选题）
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
（单选题）
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
（多选题）
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
（单选题）
You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）
（单选题）
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）
（单选题）
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables: Which MERGE statement is valid?（）
（单选题）
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which UPDATE statement is valid?（）
（多选题）
ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）
