> > >

Oracle 10g Database Administration MCQs

Which three statements among the following are true about rebuilding indexes?

The ALTER INDEX REBUILD command is used to change the storage characteristics of an index

Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature

Oracle8i allows for the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table

When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild itself

Answer

Correct Answer: The ALTER INDEX REBUILD command is used to change the storage characteristics of an index

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle 10g Database Administration Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More Oracle 10g Database Administration MCQ Questions

Oracle 10g Database Administration Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it