A redo log fil

第1题：

第2题：

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

• A、 The archived redo log files will be overwritten.
• B、 The archived redo log files are deleted automatically.
• C、 The archived redo log files should be moved to some other location.
• D、 The archived redo log files are still maintained because the file names are unique.

第3题：

第4题：

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

• A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
• B、 Before the instance starts， you receive an error about the missing redo log files of a group.
• C、 The instance starts and the database opens with an error message written to the alert log file.
• D、 The instance starts and the database opens because two redo log groups still exist.
• E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

第5题：

You have the following online redo log configuration：    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）

• A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；
• B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；
• C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；
• D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；
• E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；
• F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；

第6题：

以下（）进程负责将Redo Log buffer里的数据写入Online redo log files。

• A、CKPT
• B、ARCn
• C、LGWR
• D、DBWn

第7题：

Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）

• A、current redo log and inactive redo log
• B、checkpoint position to end of redo log
• C、beginning of redo log to end of redo log
• D、all redo logs before the point of last commit
• E、beginning of redo log to checkpoint position

第8题：

第9题：

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）

• A、The backup fails because one of the archived redo log files is missing. 
• B、The backup succeeds but it would be without the missing archived log. 
• C、During backup, you are prompted for the alternative destination for the missing archived redo log file. 
• D、The backup succeeds because it fails over to one of the alternative archived redo log destinations. 

第10题：

The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） 

• A、 The database will hang.
• B、 The database will be crashed.
• C、 The database will be shut down.
• D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group