Which two changes and their effect on the system can be tested by using the Database Replay feature？（）A、 multiplexing of the control fileB、 adding the redo log member to the databaseC、 database and operating system upgradesD、 changing the database storage

第1题：

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

第2题：

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

第3题：

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

第4题：

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’

第5题：

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

第6题：

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.

第7题：

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

• A、 loss of one of the tablespaces
• B、 loss of a system data file
• C、 loss of one of the control files
• D、 loss of a tempfile
• E、 loss of the only member of an unarchived redo log group
• F、 loss of a member from each redo log group

第8题：

Which two database operations can be performed at the MOUNT stage of database startup？（）

• A、renaming of data files
• B、dropping the database user
• C、renaming of control files
• D、multiplexing of control files
• E、configuring the database in ARCHIVELOG mode

第9题：

Which three tasks can be performed using a duplicate database？（）

• 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

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

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

第16题：

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）.

第17题：

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

第18题：

Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

• A、Data files
• B、Control files
• C、Parameter file
• D、Online redo log files
• E、Server parameter file

第19题：

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

• A、Creating the control file for the duplicate database
• B、Restoring the target data files to the duplicate database
• C、Performing complete recovery using all available backups
• D、Generating a new, unique DBID for the duplicate database
• E、Copying the online redo log files from the target database to the duplicate database

第20题：

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）

• A、 Creating the control file for the duplicate database
• B、 Restoring the target data files to the duplicate database
• C、 Performing complete recovery using all available backups
• D、 Generating a new， unique DBID for the duplicate database
• E、 Copying the online redo log files from the target database to the duplicate database

第21题：

第22题：

第23题：