单选题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.

第1题：

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

• A、You must have change tracking enabled in your database
• B、Your database must be running in NOARCHIVELOG mode
• C、To back up a tablespace, it must be in backup mode
• D、To back up a tablespace, it must first be taken offline

第2题：

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

• A、configure the database to run in ARCHIVELOG mode
• B、configure the Flash Recovery Area to enable automatic database backup
• C、schedule the database backup using DBMS_JOB package after creating the database
• D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
• E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

第3题：

You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent. Which type of backup should you perform?（）

• A、standard backup set
• B、image copy
• C、compressed backup
• D、user-managed backup

第4题：

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）

• A、You are backing up to tape and your tape device performs its own compression.
• B、You are making image copies, and you have not enabled tablespace compression.
• C、You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
• D、You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
• E、You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.

第5题：

You are the network administrator for your company. The network consists of a single Active Directory domain. All domain controllers run Windows Server 2003, and each one has a locally attached tape device. You need to back up each domain controller. Your backup process must fulfill the following requirements: System recovery must be possible in the event of server failure. The system configuration and all current dynamic disk configurations must be backed up. Other data partitions do not need to be backed up. What should you do?（）

• A、Use the Backup utility to back up the system files and to create an Automated System Recovery (ASR) disk.
• B、Use the Backup utility to back up the contents of all mounted drives.
• C、Use the Backup utility to back up only the System State data.
• D、Use the Copy command to copy C:/windows and its subfolders to a shared folder on the network.
• E、Use the Xcopy command to copy C:/windows and its subfolders to a shared folder on the network.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）

• A、 Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
• B、 Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
• C、 Use compression when performing tape backups
• D、 Configure multiple SBT channels

第14题：

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

• A、Open the database in NORMAL mode
• B、Open the database in read-only mode
• C、Open the database in RESTRICTED mode
• D、Open the database with the RESETLOGS option

第15题：

You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）

• A、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；
• B、 CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；
• C、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；
• D、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；

第16题：

Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

• A、 V$DATABASE
• B、 V$UNDOSTAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$FLASHBACK_DATABASE_STAT

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：