单选题You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more con

第1题：

You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）

• A、The instance would normally abort.
• B、The instance would not be affected.
• C、The instance would be invalid， so would have to be aborted.
• D、The instance would remain open， but the LGWR process would fail.
• E、The instance would remain open and would automatically create the missing file

第2题：

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of 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

第3题：

第4题：

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

• A、Start the instance and open the database， instance recovery automatically recoverscontrol files
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
• C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
• D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
• E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

第5题：

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.

第6题：

You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

• A、Application Server Control
• B、Oracle Management Service
• C、Oracle Enterprise Manager Repository
• D、Oracle Enterprise Manager Database Control

第7题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第8题：

You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）

• A、You performed rollback after commit.
• B、If a log switch occurs in your database.
• C、Thearchiverfails to generate an archived log file.
• D、Instance recovery fails to find one of the redo log files.
• E、A long-running query is unable to get read-consistent image.
• F、If you perform manual undo management operations in auto mode.

第9题：

You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

• A、Increase the size of redo log files
• B、Increase the size of redo log buffer
• C、Increase the number of redo log files
• D、Place the redo log files on a separate disk
• E、Decrease the number of redo log groups to two
• F、Increate the number Log Writer （LGWR） process

第10题：

You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

• A、All control files are opened
• B、All redo files are opened
• C、The password file is opened
• D、The parameter file is opened
• E、All online data files are opened