多项选择题You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

A. You must ensure that the SALES database is mounted or open.
B. You must restore a backup control file to perform a block media recovery.
C. You must take the tools01.dbf data file offline before you start a block media recovery.
D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E. You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）

A. drop and re-create the read-only tablespaces
B. rename the read-only data files to their correct file names
C. change the tablespace status from read/write to read-only
D. re-create the read-only tablespace because it is automatically removed

点击查看答案
2.单项选择题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）

A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor （ADDM）

点击查看答案

最新试题

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

题型：单项选择题

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）. In which two sources would you find the DBID？ （）

题型：多项选择题

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file.Which method would you use for recovery？（）

题型：单项选择题

View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）

题型：单项选择题

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？（）

题型：单项选择题

In which case would you use the Flashback Database feature to perform a recovery？（）

题型：单项选择题

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？（）

题型：多项选择题

You disabled the Flashback Database feature by using the following command： SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）

题型：单项选择题

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user­managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

题型：单项选择题

You have a read­only tablespace on read­only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read­only tablespace was read/write when the control file was backed up. What should you consider？（）

题型：单项选择题