You moved the index EMP_NO_INDX from one tablespace to anoth

第1题：

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（） 

• A、 Index-organized table
• B、 Mapping Table
• C、 Clustered Table
• D、 Journal Table

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

第4题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第5题：

Which two statements are correct regarding the Oracle Flashback Drop feature？ （）

• A、 Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
• B、 You can flash back a dropped table provided row movement has been enabled on the table.
• C、 If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
• D、 When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
• E、 When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
• F、 If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

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

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

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

第10题：

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

• A、 by using the Flashback Database feature
• B、 by using RMAN incomplete recovery
• C、 by performing a user-managed incomplete recovery
• D、 by dropping and re-creating the index tablespace