> > >

Oracle 8 DBA MCQs

Your database has a tablespace called Data which contains all tables and indexes. For performance reasons, you want to shift all the indexes into a new tablespace called Idx. Which technique will you adopt?

Drop each index using the Drop Index command and then recreate it by specifying the Tablespace clause in the Create Index command.

Export all the objects from the database using the Indexfile option of the Export utility and then use the Import utility.

Use the Alter Index command.

Use the Alter Table command.

None of the above.

Answer

Correct Answer: Export all the objects from the database using the Indexfile option of the Export utility and then use the Import utility.

Explanation:

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

Oracle 8 DBA Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it