单选题Which statement about using RMAN stored scripts is true?（）A To create and execute an RMAN stored script, you must use a recovery catalog.B When executing a stored script and a command fails, the remainder of the script is executed, and a message is wri

第1题：

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts.
• B、 Recovery is faster if data is stored in catalog in addition to the control file.
• C、 You can store backup Information of all registered databases in one place.
• D、 Database backups are automatically deleted when they are older than the specified time period.

第2题：

Which of the following commands must be issued to remove a stored script from the recovery catalog？（）

• A、DELETE SCRIPT
• B、ERASE SCRIPT
• C、REMOVE SCRIPT
• D、UNCATALOG SCRIPT

第3题：

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（） (Choose two.)

• A、stored scripts in the recovery catalog.
• B、backups that can be deleted from disk.
• C、backup sets and image copies are obsolete.
• D、backups that do not have the AVAILABLE status in the RMAN repository.

第4题：

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?（）

• A、Stored scripts in the recovery catalog
• B、Backups that can be deleted from disk
• C、Backup sets and images copies that are obsolete
• D、Backups that do not have the AVAILABLE status in the RMAN repository

第5题：

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?（）

• A、Stored scripts in the recovery catalog
• B、Backups that can be deleted from disk
• C、Backup sets and images copies that are obsolete
• D、Backups that do not have the AVAILABLE status in the RMAN repository

第6题：

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

• A、The backup status will be marked expired in RMAN recovery catalog.
• B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
• C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
• D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
• E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

第7题：

You issue this RMAN command：   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   （database include current controlfile）；   sql ‘alter database archive log current’；   }  Which three statements are true about the Level0Backup script you just created？（）

• A、The script is stored only in the control file.
• B、The script is stored only in the recover catalog.
• C、The script can be executed only by using the RMAN RUN command.
• D、The commands of the script can be displayed with the LIST command.
• E、The commands of the script can be displayed with the PRINT command.
• F、The commands of the script can be displayed with the REPORT command.

第8题：

Given the script   create script db_backup_datafile_script  {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；}   What is the result of running this command？（）  

• A、 The script will fail since you instructed RMAN to back up only one datafile rather than two
• B、 The script will successfully back up datafile 3 without error
• C、 The script will fail since it uses a substitution variable which is not supported
• D、 The execute script command will prompt for the value of and2 since it’s not included in the command
• E、 The script will fail because you cannot use the plus archivelog command when backing up

第9题：

第10题：

第11题：

第12题：

第13题：

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（）

• A、stored scripts in the recovery catalog
• B、backups that can be deleted from disk
• C、backup sets and image copies are obsolete
• D、backups that do not have the AVAILABLE status in the RMAN repository RMAN

第14题：

Which statement is true regarding virtual private catalogs?（）

• A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
• B、The virtual private catalog owner cannot create and modify the stored scripts.
• C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
• D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

第15题：

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.

第16题：

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）

• A、It is a SQL script.
• B、It is a PL/SQL file.
• C、It is an operating system （OS） file.
• D、It is a Recovery Manager （RMAN） script

第17题：

Which statement about using RMAN stored scripts is true？（）  

• A、 To create and execute an RMAN stored script，you must use a recovery catalog.
• B、 When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.
• C、 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
• D、 When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.

第18题：

Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)

• A、You can use RMAN stored scripts
• B、Recovery is faster if data is stored in catalog in addition to the control file
• C、You can store backup information of all registered databases in one place
• D、Database backups are automatically deleted when they are older than the specified time period

第19题：

Using the LIST command in Recovery Manager （RMAN）， which two pieces of information from the RMAN repository can be listed？ （）

• A、backups that can be deleted
• B、stored scripts in the recovery catalog
• C、backup sets and image copies that are obsolete
• D、only the most recent backup sets or image copies
• E、backups that do not have the AVAILABLE status in RMAN repository

第20题：

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts
• B、 Recovery is faster if data is stored in catalog in addition to the control file
• C、 You can store backup information of all registered databases in one place
• D、 Database backups are automatically deleted when they are older than the specified time period

第21题：

第22题：

第23题：

第24题：