单选题Which command is used to begin a tablespace point-in-time recovery？（）A  Restore tablespaceB  Recover tablespaceC  Tablespace recoverD  Recover to timeE  recover datafile

第1题：

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

第2题：

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

第3题：

第4题：

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

第5题：

Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）  

• A、 shutdown restore datafile 4； recover datafile 4； alter database open；
• B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；
• C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；
• D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；
• E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；

第6题：

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.

第7题：

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

• A、Restore the data file and perform incomplete recovery.
• B、Restore the data file and perform point-in-time recover.
• C、Drop the tablespace and lose all data in the tablespace.
• D、Restore the database and lose all data since the last backup.

第8题：

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）

• A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 
• B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 
• C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
• D、Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 

第9题：

Which of the following commands cannot be executed when the database open？（）

• A、RECOVER DATABASE
• B、RECOVER TABLESPACE
• C、RECOVER DATAFILE
• D、ALTER DATABASE RECOVER DATAFILE

第10题：

Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）

• A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
• B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.