单选题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 

第1题：

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

• A、 take data files from the read-only tablespace offline before performing a recovery
• B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
• C、 drop the read-only tablespace and re-create the tablespace after recovery
• D、 perform a recovery； status of the tablespace in control file will be changed automatically

第2题：

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

第3题：

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

第4题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）  

• A、You should implement Differential backup 
• B、You should implement Database snapshots
• C、You should implement Primary filegroup backup 
• D、You should implement Transaction log backup

第5题：

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

• A、backup pieces
• B、control file autobackups
• C、copies of all the parameter files
• D、trace file generated using BACKUP CONTROLFILE TO TRACE

第6题：

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

• A、backup of offline tablespaces
• B、backup of read­only tablespaces
• C、backup of system­critical tablespaces
• D、backup of online， locally managed tablespaces
• E、backup of read/write dictionary­managed tablespaces

第7题：

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

第8题：

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

• A、 Backup of offline tablespaces.
• B、 Backup of read-only tablespaces.
• C、 Backup of system-critical tablespaces.
• D、 Backup of online， locally managed tablespaces.
• E、 Backup of read/write dictionary-managed tablespaces.

第9题：

You performed a backup of the flash recovery area by using the following command for the first time： RMAN> BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up？（）

• A、flashback logs
• B、current control file
• C、control file autobackups
• D、incremental backup sets

第10题：

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You perform a normal backup of Server1 every Saturday. You need to implement a backup strategy for Server1 to meet the following requirements: ·Minimize the time required to restore files. ·On weekdays, back up only files that have changed since the Saturday backup. Which type of backup should you perform on weekdays? （）

• A、copy
• B、daily
• C、differential
• D、incremental