单选题You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）AWhen a successful backup is recorded in the RMAN repository， then a backup of the current control file is perform

第1题：

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

第2题：

You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of the above command？（）

• A、 After two days， the backup will be marked obsolete.
• B、 After two days， the backup will be deleted from the media.
• C、 If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.
• D、 If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.

第3题：

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

• A、RMAN would use the current operating system location to place the backup.
• B、RMAN would use the control file of the target database to maintain the backup.
• C、RMAN would use the recovery catalog of the target database to maintain the backup.
• D、RMAN would use the control file of the target database to maintain the backup metadata. 
• E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

第4题：

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）

• A、 By using the trace file.
• B、 By using the alert log file.
• C、 By using the database ID
• D、 By using the server parameter file.
• E、 By using the V$CONTROLFILE view.
• F、 By using the autobackup format configuration setting.

第5题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.

第6题：

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）

• A、by using the trace file
• B、by using the alert log file
• C、by using the database ID
• D、by using the server parameter file
• E、by using the V$CONTROLFILE view
• F、by using the autobackup format configuration setting

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

• A、cannot be used in RMAN
• B、by starting up the database again
• C、by using the CATALOG command of RMAN
• D、by using the RECOVER CATALOG command in RMAN
• E、by re-creating the target control file to rebuild the RMAN repository

第15题：

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.

第16题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）

• A、 A tablespace is taken offline.
• B、 The database instance is restarted.
• C、 A new data file is added to an existing tablespace.
• D、 A successful backup is recorded in the RMAN repository.
• E、 The RMAN connection is disconnected from the target database.

第17题：

You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

• A、 rman TARGET / NOCATALOG
• B、 rman TARGET sys/password
• C、 rman TARGET sys/password AS SYSDBA
• D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

第18题：

When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）

• A、At the end of every RUN block. 
• B、After every SET CONTROLFILE AUTOBACKUP FORMAT command. 
• C、After every BACKUP or COPY command issued at the RMAN prompt. 
• D、At the end of every RUN block if the last command in the block was either BACKUP or COPY. 
• E、Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. 
• F、After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：