Question:Which of the following statements are correct with regard to Rebuilding Indexes? 

A The ALTER INDEX REBUILD command is used to change the storage characteristics of an index 
B Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature 
C Oracle8i allows the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table 
D When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild 

+ Answer
D 

+ Explanation
not sure

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description