（单选题）
You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）
A Rebuild the index.
B Coalesce the index.
C Drop and re-create the index in the new tablespace.
D Relocate the index using the ALTER INDEX...MOVE statement.
正确答案
答案解析
略
相似试题
（单选题）
You are configuring for Oracle Shared Server. Which service is required？ （）
（多选题）
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
（单选题）
How are messages displayed when you use the SRW.MESSAGE packaged procedure? （）
（单选题）
In which situation are you NOT required to perform an incomplete recovery？（）
（单选题）
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）
（单选题）
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
（单选题）
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
（多选题）
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）
（单选题）
Which command would you use to determine what database backups are currently available for restore?（）
（单选题）
Which command would you use to determine what database backups are currently available for restore？（）
