You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  A、 Repair the corrupted blocks. If any. In the backup createdB、 Popu

第1题：

As A DBA， which of the following methods can you use to make a backup of your table？（）

• A、Recover Manager （RMAN） utility
• B、Import utility
• C、Export utility
• D、O/S backup command

第2题：

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

• A、Corrupted blocks, if any, are repaired.
• B、Checks are performed for physical corruptions.
• C、Checks are performed for logical corruptions.
• D、Checks are performed to confirm whether all database files exist in correct locations
• E、Backup sets containing both data files and archive logs are created.

第3题：

第4题：

You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）  

• A、 A list of files that require a backup within 3 days
• B、 A list of files requiring more than 3 days of archivelogs to apply
• C、 A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
• D、 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

第5题：

You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

• A、SYSDBA
• B、SYSOPER
• C、No system privileges are required for the RMAN user.
• D、Only SYS user can connect and execute RMAN commands on a target database.

第6题：

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

• A、flash back the corrupted blocks
• B、use the DBMS_REPAIR package
• C、use the RMAN TSPITR command
• D、use the RMAN BLOCKRECOVER command
• E、use the RESTORE DATABASE and RECOVER DATABASE commands
• F、investigate the time at which the corruption occurred and perform a point-in-time recovery

第7题：

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

• A、 run { open script backup_database； run script backup_database }
• B、 run { engage script backup_database； }
• C、 run { run script backup_database； }
• D、 Run { execute script backup_database； }
• E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

第8题：

第9题：

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.

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