单选题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A flash back the databaseB perform point-in-time recoveryC perform a full 

第1题：

In which scenario will you perform a cancel-based recovery？（）

• A、 when a tablespace is dropped and you have only RMAN-based backup of the database
• B、 when a table is dropped and stored in the Recycle Bin
• C、 when you are required to recover an existing table to its previous state
• D、 when a tablespace is dropped and you have only a user-managed full backup of the database

第2题：

Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

• A、Until last commit
• B、Until the time you perform recovery
• C、Until the time the date file got corrupted
• D、Until the point where the last transaction begun
• E、You cannot recover the SYSTEMtablespaceand must re-create the database.

第3题：

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

• A、You must have change tracking enabled in your database
• B、Your database must be running in NOARCHIVELOG mode
• C、To back up a tablespace, it must be in backup mode
• D、To back up a tablespace, it must first be taken offline

第4题：

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

• A、 Restore the lost data file from the backup， and then flash back the database.
• B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
• C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
• D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
• E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

第5题：

You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）

• A、restore the tablespace from the backup; there is no need to apply the redo information 
• B、restore the full database to recover the data up to the point when you performed the backup 
• C、restore the tablespace from the backup， and then perform a recovery using the backup control file
• D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

第6题：

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

• A、flash back the database
• B、perform point-in-time recovery
• C、perform a full database recovery
• D、drop and re-create the tablespace
• E、use Recovery Manager （RMAN） to recover the database

第7题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

• A、 UNTIL SEQUENCE
• B、 UNTIL SCN
• C、 UNTIL CHANGE
• D、 UNTIL CANCEL

第8题：

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

第9题：

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

第10题：

Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

• A、 DROP TABLESPACE temp1；
• B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；
• C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
• D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；