多选题In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）Athe alert log fileBthe core dump filesCthe change tracking fileDthe user sess

第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 database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）

• A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
• B、They are created only in the Fast Recovery Area.
• C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
• D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

第3题：

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

• A、the alert log file
• B、the core dump files
• C、the change tracking file
• D、the user session trace files
• E、the database audit trail files
• F、the background process trace files

第4题：

The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）

• A、 Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.
• B、 Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.
• C、 Issue the SERVICES command at the LSNRCTL> prompt.
• D、 Issue the STATUS command at the LSNRCTL> prompt.

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

In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

• A、the V$LOG view
• B、the V$DBFILE view
• C、the V$LOGFILE view
• D、the V$INSTANCE_RECOVERY view
• E、Oracle Enterprise Manager Database Control

第8题：

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

第9题：

You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）

• A、 The location used for control files.
• B、 The location used for redo log files.
• C、 The location set by using $ORACLE_BASE
• D、 The location set by using $ORACLE_HOME
• E、 The location set by using CORE_DUMP_DEST
• F、 The location set by using BACKGROUND_DUMP_DEST

第10题：

You executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）

• A、USER_DUMP_DEST
• B、CORE_DUMP_DEST
• C、TRACE_DUMP_DEST
• D、BACKUP_DUMP_DEST
• E、BACKGROUND_DUMP_DEST