单选题When performing recover of a database in NOARCHIVELOG mode with RMAN， the target database must be in the （） state to restore the control file.A OPENB IDLEC MOUNTD NOMOUNT

第1题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）

• A、The database is in NOMOUNT state.
• B、The database is in ARCHIVELOG mode and the tablespace is online.
• C、The database is in ARCHIVELOG mode and the tablespace is offline.
• D、The database is in NOARCHIVELOG mode and the tablespace is online.
• E、The database is in NOARCHIVELOG mode and the tablespace is offline.

第2题：

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

• A、 Database datafiles
• B、 Control files
• C、 Archived redo logs
• D、 Online redo logs
• E、 Flashback logs

第3题：

You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

• A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
• B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
• C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
• D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

第4题：

you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

• A、 True
• B、 False

第5题：

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

第6题：

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）

• A、 MMON
• B、 LGWR
• C、 ARCH
• D、 ARWR
• E、 COPY

第7题：

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

• A、 Enable flashback logging.
• B、 Start the database in the ARCHIVELOG mode.
• C、 Issue the ALTER DATABASE FLASHBACK ON； command.
• D、 Set the FAST_START_MTTR_TARGET initialization parameter.

第8题：

When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

• A、Until SCN
• B、Until time
• C、Until cancel
• D、Recover using backup control file.

第9题：

When performing an incomplete recover of the whole database， which data files must you restore？ （）

• A、Only the damaged or lost data files.
• B、All of the data files of the database.
• C、Only the data files belonging to the SYSTEM tablespace.
• D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

第10题：

Which three actions are required to configure the Flashback Database？（）  

• A、 set Flash Recovery Area
• B、 enable Flashback logging
• C、 create FLASHBACK tablespace
• D、 start the database in the ARCHIVELOG mode
• E、 start the database in the NOARCHIVELOG mode