You have only two redo log groups and these groups get overw

第1题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

• A、archival
• B、log writer
• C、database writer
• D、system monitor
• E、process monitor
• F、change tracking writer

第2题：

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

• A、 ALTER DATABASE DROP LOGFILE GROUP 1
• B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
• C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
• D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

第3题：

第4题：

Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）

• A、any control file
• B、any archive log file
• C、one of the redo log members
• D、loss of the initialization parameter file
• E、any data file belonging to the default permanent tablespac

第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题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

• A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
• B、You must define directories for two online redo log groups and three copies of the control file. 
• C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
• D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

第7题：

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

• A、You should perform a log switch
• B、You should make a backup of the database
• C、You should switch the database to the NONARCHIVELOG mode
• D、You should shut down the database instance and perform a complete database recovery

第8题：

In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）

• A、increase the size of the redo log buffer
• B、increase the number of redo log groups
• C、increase the number of log writer processes
• D、increase the number of ARCn processes
• E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

第9题：

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.

第10题：

In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

• A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
• B、 when all the online redo log groups are not multiplexed and one log group is missing
• C、 when all the control files are missing
• D、 when some important tables are deleted from the database and purged from the Recycle Bin