You noticed that the index tablespace in your database requi

第1题：

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

第2题：

While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

• A、 A primary key must have been created.
• B、 A mapping table must have been created.
• C、 An overflow tablespace must have been specified.
• D、 The PCTTHRESHOLD option must have been specified.

第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题：

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.

第5题：

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

第6题：

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

第7题：

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

第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 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

第10题：

Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

• A、 The queries that are currently executing will abort and an error message will be returned to the user.
• B、 The queries that are currently executing will execute normally but future queries will not executed.
• C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
• D、 The currently executing and future queries will execute normally， but will be slower