You lost the index tablespace in your database. You decided 

第1题：

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

• A、flash back the database
• B、import the temporary tablespace from the last export
• C、restore all the data files and temporary files from the last full database backup and perform a recovery
• D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

第2题：

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

• A、Restore and recover the datafile. 
• B、Restore and recover the tablespace. 
• C、Restore and recover the database. 
• D、Restore and recover the control file. 
• E、Restore and recover the parameter file.

第3题：

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  

• A、 Restore and recover the datafile.
• B、 Restore and recover the tablespace.
• C、 Restore and recover the database.
• D、 Restore and recover the control file.
• E、 Restore and recover the parameter file.

第4题：

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

• A、renaming the control files
• B、dropping a user in your database
• C、enabling or disabling redo log archiving
• D、dropping a tablespace in your database
• E、re-creating the control files， after you lost all the control files in your database

第5题：

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

第6题：

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

第7题：

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

第8题：

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.

第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-in-time 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.