You have discovered that a disk failure occurred on DISK1 where the data files belonging to the SYSTEM and USER_DATA tablespaces is stored. The database is currently open and you need to recover the data files. You will restore the data files to DISK2. What is the correct sequence of RMAN commands to restore and recover the data files？（）

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to （）

单选题查看答案

You need to rename a data file of a tablespace. How would you perform this？（）

单选题查看答案

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin.  Which statement is correct？（） 

单选题查看答案

Exhibit： View the Exhibit.You have more than one table in the recycle bin having the same original name， DEPT2. You do not have any table with the nameDEPT2 in your schema. You executed the following command：PURGE TABLE dept2； Which statement is correct in this scenario？（）

单选题查看答案

You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

单选题查看答案

Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

单选题查看答案

Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）  

单选题查看答案

You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB.  Which configuration could have enabled the block selection of 16 KB（）

单选题查看答案

You have configured the ASM instance for the PROD database of iPod Corporation. You have specified the following parameter values in the initialization parameter file：   DB_CREATE_FILE_DEST=’devices/grp1/P’   DB_CREATE_ONLINE_LOG_DEST_1=’devices/d_grp2/Q’        DB_CREATE_ONLINE_LOG_DEST_2=’devices/d_grp3/R’        BACKGROUND_DUMP_DEST=’devices/d_grp1/S’   You have added a new redo log group that contains two redo log members. Where are the redo log members stored？（）

单选题查看答案

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）  

单选题查看答案