单选题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A Nothing happensB Oracle will automatically switch redo logs when detected C Oracle eventually won'

第1题：

The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.

• A、large pool
• B、shared pool
• C、data buffer cache
• D、redo log buffer
• E、data dictionary cache

第2题：

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  

• A、the value of the UNDO_RETENTION initialization parameter
• B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
• C、the online redo log files size
• D、the number of redo log members in a group

第3题：

You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

• A、This operation resets the SCN for the database.
• B、This operation creates a new incarnation of the database.
• C、This operation moves all the redo log files to a different location.
• D、This operation deletes the old redo log files and creates new redo log files.
• E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

第4题：

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

第5题：

As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

• A、 Shut down the database
• B、 Clear the online redo log
• C、 Back up the database
• D、 Checkpoint the database
• E、 Call Oracle support

第6题：

Archived redo logs can be copied to more than one destination by Oracle.（）

• A、 True
• B、 False

第7题：

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

• A、Oracle Flashback uses undo information to construct consistent data. 
• B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
• C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
• D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

第8题：

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

• A、 The log sequence is reset to 0.
• B、 All the online redo logs are deleted.
• C、 All the archived redo logs from a previous incarnation become useless.
• D、 The full database backup taken from a previous incarnation can be used in future.
• E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

第9题：

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

• A、Shared pool 
• B、Control file 
• C、SGA 
• D、PGA

第10题：

You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

• A、 multiplexed control files
• B、 RMAN obsolete backups
• C、 multiplexed online redo log files
• D、 archived redo logs that have not been copied to tape