Question:Which three statements among the following are true about 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 for 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 itself 

+ Answer
A 

+ 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