单选题

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

    单选题查看答案