单选题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 SYSDBAB SYSOPERC No system privileges are requi

第1题：

You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.

• A、4，1，5，6，3，2
• B、4，3，1，5，6，2
• C、4，5，1，3，2，6
• D、5，4，1，3，2，6
• E、5，4，1，3，6，2

第2题：

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

• A、’SQL ALTER DATABASE OPEN’；
• B、SQL ALTER DATABASE ’OPEN’；
• C、OPEN DATABASE；
• D、DATABASE OPEN

第3题：

第4题：

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.

第5题：

You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）

• A、RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
• B、RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
• C、RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 
• D、RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

第6题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

• A、You need to perform the restore and recover operations manually, because the backup was made manually. 
• B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
• C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
• D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

第7题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第8题：

第9题：

When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）

• A、RMAN keeps a list of archive logs in a text file.
• B、The DBA must manually tell RMAN which archive logs to backup.
• C、RMAN has access to target control file and/or catalog information.
• D、RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

第10题：

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.