首页计算机考试Oracle认证
(单选题)

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; 

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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?()

    答案解析

快考试在线搜题