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 setB、 image copyC、 compressed backupD、 user-managed backup
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
相关考题：
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）A. 8, 1, 3, 2, 4, 5, 7, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8
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 FALSEB.Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC. Use compression when performing tape backupsD. Configure multiple SBT channels
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 setB. image copyC. compressed backupD. user-managed backup
You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)A．Perform. a combination of full database and filegroup backups.B．Perform. a combination of full database and file backups.C．Perform. a combination of full database, differential, and transaction log backups.D．Back up the data to a local tape drive.E．Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.
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 databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline
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.
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 FALSEB、 Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC、 Use compression when performing tape backupsD、 Configure multiple SBT channels
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 modeB、configure the Flash Recovery Area to enable automatic database backupC、schedule the database backup using DBMS_JOB package after creating the databaseD、schedule the database backup using Recovery Manager （RMAN）commands after creating the databaseE、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database
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
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 modeB、Open the database in read-only modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option
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 filesB、 password fileC、 control fileD、 change tracking file
You issue the following command： RMANCONFIGURE 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.
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 setB、image copyC、compressed backupD、user-managed backup
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；
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.
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$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
You want to perform a backup of your database to tape. Which backup format can you use？（）A、backup set onlyB、image copy onlyC、only user-managed backupD、both image copy and backup setE、only incremental image copy backup
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.
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.
单选题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；
多选题You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）AYou are backing up to tape and your tape device performs its own compression.BYou are making image copies, and you have not enabled tablespace compression.CYou are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.DYou are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.EYou are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
单选题You are the network administrator for The network consists of a single Active Directory domain named All domain controllers run Windows Server 2003, and all client computers run Windows XP Professional. Each domain server has a locally attached tape device. You need to back up each domain controller. Your backup process must fulfil the following requirements: a. System recovery must be possible in the event of server failure. b. The system configuration and all current dynamic disk configurations must be backed up. c. Other data partitions do not need to be backed up. What should you do?（）AUse the Backup utility to back up the system files and to create an Automated System Recovery (ASR) disk.BUse the Backup utility to back up the contents of all mounted drives.CUse the Backup utility to back up only the System State data.DUse the Copy command to copy C:/windows and its subfolders to a shared folder on the network.EUse the Xcopy command to copy C:/windows and its subfolders to a shared folder on the network.
单选题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?（）AYou must have change tracking enabled in your databaseBYour database must be running in NOARCHIVELOG modeCTo back up a tablespace, it must be in backup modeDTo back up a tablespace, it must first be taken offline
单选题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 setB image copyC compressed backupD user-managed backup
单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A 8， 1， 3， 2， 4， 5， 7， 6B 1， 8， 3， 4， 2， 5， 7， 6C 1， 3， 4， 2， 8， 5， 6， 7D 1， 3， 2， 4， 6， 5， 7， 8
单选题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 filesB password fileC control fileD change tracking file
单选题You want to perform a backup of your database to tape. Which backup format can you use？（）Abackup set onlyBimage copy onlyConly user-managed backupDboth image copy and backup setEonly incremental image copy backup