多选题Which of the following are valid until command options when attempting point-in-time recovery in RMAN？（）Auntil timeBuntil changeCuntil sequenceDuntil SCNEuntil commit

第1题：

You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

• A、back up the control file to trace
• B、bring database to the MOUNT state
• C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
• D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

第2题：

What RMAN command is used to execute a tablespace point-in-time recovery？（）

• A、 recover
• B、 duplicate
• C、 restore
• D、 copy
• E、 None of the above

第3题：

第4题：

Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）

• A、New channels for restore and recovery tasks
• B、New name for the data files of the tablespace
• C、Auxiliary name for the data files of the tablespace
• D、Auxiliary destinations for an auxiliary set of data files

第5题：

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

第6题：

You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）

• A、 The backup would be marked as invalid.
• B、 The backup would be marked as obsolete.
• C、 The backup would be removed from the media.
• D、 The backup would be removed from the RMAN repository.

第7题：

Which of the following statement is incorrect regarding RMAN？（）

• A、It detects corrupt blocks.
• B、It performs only offline database backups.
• C、It omits empty blocks during backups.
• D、It performs tablespace point-in-time recovery （TSPITR）.

第8题：

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  

• A、 Issue the grant command from the SYS user （or equivalent） of the target database.
• B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
• C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
• D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
• E、 Issue the grant command from RMAN when connected to the target database.

第9题：

To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

• A、OPEN
• B、MOUNT
• C、NOMOUNT
• D、CLOSE

第10题：

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.