单选题You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）AThe index tablespace contains bitmap indexes.BThe index tablespace contains more tha

第1题：

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.

第2题：

You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes？（）

• A、Data Pump
• B、SQL scripts
• C、SQL*Loader
• D、Flashback database
• E、Recovery Manager （RMAN） script

第3题：

At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）

• A、 Start the database in OPEN mode， and create a new index tablespace.
• B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.
• C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
• D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

第4题：

In which scenarios would you rebuild an index？（）

• A、 when you need to disable the index usage
• B、 when you need to change storage options
• C、 when you need to enable index monitoring
• D、 when you need to move the index to another tablespace

第5题：

Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

• A、 undo tablespace
• B、 index tablespace
• C、 read-only tablespace
• D、 temporary tablespace

第6题：

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

• A、 SQL scripts
• B、 Recovery Manager （RMAN） script
• C、 Data Pump
• D、 SQL*Loader
• E、 Flashback database

第7题：

Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

• A、 Drop and re-create the inbox.
• B、 Coalesce the ORDERS_IND index.
• C、 Coalesce the INDEXES tablespace.
• D、 Drop and re-create the ORDERS table.
• E、 Rebuild the index online and move it to another tablespace.

第8题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）

• A、ONLINE
• B、REVERSE
• C、PARALLEL
• D、COMPRESS
• E、NOLOGGING
• F、COMPUTE STATISTICS

第9题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

• A、 ONLINE
• B、 REVERSE
• C、 PARALLEL
• D、 COMPRESS
• E、 NOLOGGING
• F、 COMPUTE STATISTICS

第10题：

You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）

• A、The index tablespace contains bitmap indexes.
• B、The index tablespace contains more than one data file.
• C、The index tablespace supports only complete recovery.
• D、The index tablespace is not a dictionary­managed tablespace.
• E、There is a dependency relationship between a table and its indexes.