When running the tablespace point-in-time command   recover 

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

What RMAN command is used to execute a tablespace point-in-time recovery？（）

• A、 recover
• B、 duplicate
• C、 restore
• D、 copy
• E、 None of the above

第3题：

In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）  

• A、 Complete Recovery with online redo log
• B、 Complete Recovery with archived redo log
• C、 Tablespace Point-in-Time Recovery （TSPITR）
• D、 Incomplete Recovery with system change number （SCN）

第4题：

There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

• A、Only bring the tablespace back online.
• B、Only recover the tablespace and then bring the tablespace back online.
• C、Shut down the database， recover the data file and then start up the database.
• D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
• E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

第5题：

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

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

Which command is used to begin a tablespace point-in-time recovery？（）  

• A、 Restore tablespace
• B、 Recover tablespace
• C、 Tablespace recover
• D、 Recover to time
• E、 recover datafile

第8题：

When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）

• A、 The SYSTEM tablespace.
• B、 The UNDO tablespace.
• C、 All tablespaces with tables.
• D、 All tablespaces with indexes.
• E、 No tablespaces are automatically restored.

第9题：

Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command. 

• A、a， c， f， g
• B、b， c， f， h
• C、a， b， c， f， g
• D、a， b， c， f， g， h
• E、b， c， f， e， g

第10题：

In which of the following scenarios is a tablespace recovery required？（）

• A、 when recovering a lost read-only tablespace from a read-only tablespace backup
• B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
• C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
• D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only