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

You executed the following procedure to collect statistics regarding an index:       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE;   Which view will you use to determine whether you need to rebuild the index or not?() 

A INDEX_STATS

B DBA_INDEXES

C DBA_IND_COLUMNS

D V$OBJECT_USAGE

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You executed the following command in Recovery Manager (RMAN):  RMAN> RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()

    答案解析

  • (多选题)

    You executed the following commands to find the location of the alert log file: Where is the alert log file stored()

    答案解析

  • (单选题)

    You executed the following command in Recovery Manager (RMAN):  RMAN> RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?() 

    答案解析

  • (单选题)

    You execute this command in MOUNT mode: ALTER DATABASE ARCHIVELOG;  Where is the information that the database is now in ARCHIVELOG mode stored?()

    答案解析

  • (多选题)

    When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics.  Which two statements describe the implications of this?()

    答案解析

  • (单选题)

    Before a Flashback Table operation,you execute the following command:   ALTER TABLE employees ENABLE ROW MOVEMENT;   Why would you need this to be executed?()  

    答案解析

  • (单选题)

    You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()

    答案解析

  • (单选题)

    You executed the following code:   BACKUP VALIDATE DATABASE;   BLOCKRECOVER CORRUPTION LIST;  What will be the result of executing the above code?()  

    答案解析

  • (单选题)

    You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()

    答案解析

  • (单选题)

    You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement:   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;   What will be the result of executing this statement?()

    答案解析

快考试在线搜题