单选题You perform a backup using the following BACKUP command：   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE；   Which statement is true of this command？（）AA different procedure is required to restore a database from compressed backupsBThe AS COMPRESSED cla

第1题：

You need to recommend a backup solution for the VMs that meets the museum's technical requirements.   What should you include in the recommendation？（）

• A、On each VM， perform a full server backup by using Windows Server Backup.
• B、On each physical node， perform a full server backup by using Windows Server Backup.
• C、Deploy Microsoft System Center Data Protection Manager 2010 and create a new protection group.
• D、Deploy Microsoft System Center Virtual Machine Manager （VMM） 2008 R2 and schedule checkpoints.

第2题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第3题：

第4题：

You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

• A、Datafiles
• B、 Current control file
• C、 Server parameter file （spfile）
• D、 Password file

第5题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

• A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
• B、 When a structural change is made to the database， then a backup of the current control file is performed.
• C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
• D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

第6题：

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

• A、The backup piece size will be limited to 300 MB
• B、The RMAN uses multiplexing to perform backup
• C、The operation is accomplished using the default channel available
• D、The RMAN parallelizes the backup although the parallelism is not set for a channel

第7题：

Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

• A、 The block change tracking data will be used only from the next incremental 0 backup.
• B、 The incremental backup will use change tracking data for accomplishing the backup.
• C、 The incremental backup will not use change tracking data for accomplishing the backup.
• D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

第8题：

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?（）

• A、The backup is deleted.
• B、The backup is marked unavailable.
• C、The backup overrides the backup retention policy.
• D、the backup becomes eligible for deletion according to the existing retention policy

第9题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

• A、shut down and restart the instance
• B、add new tempfiles to the temporary tablespaces after recovery
• C、perform a media recovery and open the database with the RESETLOGS option
• D、perform a media recovery and bring the database to NOARCHIVELOG mode

第10题：

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