单选题You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location

第1题：

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）

• A、the trace file
• B、the alert log file
• C、an RMAN session log file
• D、the server parameter file
• E、the formatted name of a control file autobackup

第2题：

You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

• A、The advisory memory has been turned off.
• B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
• C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
• D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
• E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

第3题：

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）

• A、 the alert log file
• B、 the server parameter file
• C、 the formatted name of a control file autobackup
• D、 an RMAN session log file
• E、 the trace file

第4题：

You work as a database administrator for Supportcenter.cn. 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.

第5题：

You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file？（）

• A、USER_DUMP_DEST
• B、CORE_DUMP_DEST
• C、ALERT_LOG_DEST
• D、ALERT_DUMP_DEST
• E、TRACE_DUMP_DEST
• F、BACKGROUND_DUMP_DEST

第6题：

You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

• A、Archiving will be disabled because the destination for the redo log files is missing.
• B、The database instance will shut down and the error details will be logged in the alert log file.
• C、Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
• D、Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

第7题：

You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

• A、Set the UNDO_RETENTION parameter to AUTO.
• B、Create an initial undo segment in undotablespace.
• C、Set the UNDO_RETENTION parameter to 900 or more
• D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
• E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

第8题：

You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）

• A、Control file
• B、Password file
• C、Parameter file
• D、Online redo log file
• E、Listener controller file
• F、Server parameter file

第9题：

You work as a database administrator for Supportcenter.cn. 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 control file. Which file is the appropriate way to perform this task？（）

• A、Shut down the instance， copy the control file to the third location and open the database.
• B、Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
• C、Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.
• D、Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
• E、Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.

第10题：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

• A、 Query the V$FLASHBACK_DATABASE_LOG view.
• B、 Query the V$FLASHBACK_DATABASE_STAT view.
• C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
• D、 Query the V$RECOVERY_FILE_DEST view.