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题：

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

第3题：

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

• A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
• B、 Just back up the database datafiles without shutting down the database.
• C、 You will have to wait until you can shut down the database to perform the backup.
• D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
• E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

第4题：

You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

• A、 redo log files
• B、 password file
• C、 control file
• D、 change tracking file

第5题：

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

第6题：

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.

第7题：

You want to perform a backup of your database to tape. Which backup format can you use？（）

• A、backup set only
• B、image copy only
• C、only user-managed backup
• D、both image copy and backup set
• E、only incremental image copy backup

第8题：

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.

第9题：

第10题：

第11题：

第12题：

第13题：

You are the network administrator for TestKing. The network consists of a single Active Directory domain. All network servers run Windows Server 2003. A member server named TestkingA has a locally attached tape device. TestkingA contains several folders and files that are encrypted by using Encrypting File System (EFS). You create a new user account for a new employee named Victoria. Victoria's user account is member of the Users group only. You need to ensure that Victoria can back up the encrypted folders and files on TestkingA. Victoria must be assigned the minimum administrative privileges needed to complete this task. What should you do?（）

• A、Add Victoria's domain user account to the Administrators group.
• B、Add Victoria's user account to the Backup Operators group.
• C、Assign the Allow - Full Control permission on the encrypted folders and files to Victoria.
• D、Designate Victoria as a recovery agent for the encrypted files.

第14题：

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

第15题：

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

第16题：

You issue the following command：   RMAN>CONFIGURE BACKUP OPTIMIZATION ON；   What is the result of this command on your backups？（）

• A、 An incremental backup strategy will be used automatically.
• B、 Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
• C、 RMAN will configure itself for maximum performance at the cost of CPU.
• D、 RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
• E、 RMAN will automatically compress backups.

第17题：

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；

第18题：

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

第19题：

You are a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19：00 and 04：00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do？（）

• A、Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.
• B、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.
• C、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.
• D、Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.

第20题：

第21题：

第22题：

第23题：