多选题Which two changes and their effect on the system can be tested by using the Database Replay feature？（）Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to A

第1题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第2题：

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

第3题：

第4题：

You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

• A、 the system change number
• B、 the locations of the redo log files
• C、 the locations of the datafiles
• D、 the physical location of all the database changes

第5题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第6题：

Which three tasks can be performed using a duplicate database? （）(Choose three.)

• A、Testing the backup and recovery procedures
• B、Testing the upgrade of an Oracle database to a new release
• C、Testing the effect of an application changes on database performance
• D、Continuously updating archive log files from the target database to support failover

第7题：

Which two file types must be included in a closed database backup taken with operating system commands？（）

• A、data files
• B、control file
• C、password file
• D、online redo log files
• E、initialization parameter file

第8题：

Which two changes and their effect on the system can be tested by using the Database Replay feature？（）

• A、 multiplexing of the control file
• B、 adding the redo log member to the database
• C、 database and operating system upgrades
• D、 changing the database storage to ASM-managed storage

第9题：

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

• A、 The redo log file should belong to an active group.
• B、 The redo log file should belong to an inactive group.
• C、 The redo log file should belong to the current group.
• D、 The redo log file can be dropped only if all the transactions are stopped.
• E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.

第10题：

Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）

• A、data files
• B、control files
• C、parameter file
• D、online redo log files
• E、server parameter file