多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the blocks that have ever been used in the database.BThe backup performed on Sundays contains all the blocks that have changed since the last level 1backup.CThe backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.
多选题
You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape. Which two statements are true about differential incremental backups（）
A
The backup performed on Sundays contains all the blocks that have ever been used in the database.
B
The backup performed on Sundays contains all the blocks that have changed since the last level 1backup.
C
The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.
D
The backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.
参考解析
解析：
暂无解析
相关考题：
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?() A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two) A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).On Server1, you have the following backup schedule:·Normal backups every Saturday at 01:00·Differential backups every weekday at 02:00, except on SaturdayYou need to perform a complete manual backup of Server1 on Tuesday. The backup must not change which files are backed up during the next scheduled backup.Which type of backup should you perform? （）A.copyB.dailyC.incrementalD.normal
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). On Server1, you have the following backup schedule: ·Normal backups every Saturday at 01:00 Differential backups every weekday at 02:00, except on Saturday You need to perform a complete manual backup of Server1 on Tuesday. The backup must not change which files are backed up during the next scheduled backup. Which type of backup should you perform? （）A、copyB、dailyC、incrementalD、normal
You are the network administrator for The sales department stores data on a server that runs Windows Server 2003. The backup schedule for the server includes a normal backup on Sundays and incremental backups on every other day of the week. The sales department data includes a report that is created by an automated process. The report is included in the standard backup schedule for the server. The automated process runs on Wednesdays and Sundays. The process overwrites the previous version of the report. You need to be able to restore the report if the standard backup is unavailable. You need to create an additional backup for the report. The backup for the report cannot interfere with other backup jobs. What should you do?（）A、Perform a normal backup on Wednesday night and on Sunday night.B、Perform a differential backup on Wednesday night and on Sunday night.C、Perform a incremental backup on Wednesday night and on Sunday night.D、Perform a copy backup on Wednesday night and on Sunday night.
Which of the following BEST describes the difference between differential and incremental backups？（）A、 An incremental backup requires fewer tapes for restoration than a differential backup. B、 A differential backup tape takes less time than an incremental backup tape.C、 A differential backup requires fewer tapes for restoration than an incremental backup.D、 An incremental backup tape costs less than a differential backup tape.
Due to operational commitments， a system has a very short backup window during the week， but is not used from Saturday morning through Sunday at Midnight. Which of the following minimizes backup and recovery time， while providing complete data restore coverage （）A、Full backups every month， daily incremental backupsB、Full backups every month， daily differential backupsC、Full backup Saturday night， incremental backups the rest of the weekD、Full backup Saturday night， differential backups the rest of the week
What purpose would you achieve by enabling the block change tracking feature？（）A、 Eliminate the necessity for backups.B、 Perform optimized image copy backups.C、 Perform optimized incremental backups.D、 Enable checkpoint （CKPT） to perform checkpointing at every block change.E、 Enable database writer （DBWn） to write changed blocks to data files faster.
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?（）A、a cumulative level 1 backupB、a differential level 1 backupC、a full backupD、a whole backup
You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）A、 You need to mention it with every BACKUP command.B、 The block change tracking feature is used automatically by RMAN.C、 You need to configure it using the CONFIGURE command.D、 You need to set the necessary initialization parameters to direct RMAN to use the feature.
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）A、You can perform open database backups.B、You can perform closed database backups.C、You cannot perform schema-level logical backups.D、You can perform the backup of only the SYSTEM tablespace when the database is open.
You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）A、The backup performed on Sundays contains all the blocks that have ever been used in the database.B、The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.C、The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.D、The backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backup
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 database solution is managed by you. All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE statements are utilized by the procedures. A backup strategy should be implemented. The business requirements listed below should be satisfied. Point-in-time recovery for failure is supported by the backup strategy at any time of day. In addition, the least amount of disk space should be utilized by the transaction log. Which action should you perform to finish the task?（）A、To finish the task, hourly database snapshots should be utilized. B、To finish the task, the full-recovery model along with transaction log backups should be utilized.C、To finish the task, the full-recovery model along with differential backups should be utilized.D、To finish the task, the simple-recovery model along with differential backups should be utilized.
单选题You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）A You need to mention it with every BACKUP command.B The block change tracking feature is used automatically by RMAN.C You need to configure it using the CONFIGURE command.D You need to set the necessary initialization parameters to direct RMAN to use the feature.
单选题Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）AYou can perform open database backups.BYou can perform closed database backups.CYou cannot perform schema-level logical backups.DYou can perform the backup of only the SYSTEM tablespace when the database is open.
多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
单选题Which of the following BEST describes the difference between differential and incremental backups？（）A An incremental backup requires fewer tapes for restoration than a differential backup. B A differential backup tape takes less time than an incremental backup tape.C A differential backup requires fewer tapes for restoration than an incremental backup.D An incremental backup tape costs less than a differential backup tape.
多选题You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.BThe change tracking file must always be backed up when you perform a full database backup.CBlock change tracking will always reduce I/O performed during cumulative incremental backups.DMore than one database block may be read by an incremental backup for a change made to a single block.EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
单选题What purpose would you achieve by enabling the block change tracking feature？（）A Eliminate the necessity for backups.B Perform optimized image copy backups.C Perform optimized incremental backups.D Enable checkpoint （CKPT） to perform checkpointing at every block change.E Enable database writer （DBWn） to write changed blocks to data files faster.
单选题You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）ASchedule the full backups to run after the nightly index is rebuilt.BSchedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.CSchedule an additional transaction log backup to run after the nightly index is rebuilt.DSchedule a marker to be added to the transaction log before the nightly index is rebuilt.
单选题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）ARMAN reads the block change tracking file only when it performs the incremental level 0 backup.BRMAN reads the block change tracking file when it performs both incremental backups.CRMAN reads the block change tracking file only when it performs the incremental level 1 backup.DRMAN does not read the block change tracking file when it performs either incremental backup.
单选题Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?（）Aa cumulative level 1 backupBa differential level 1 backupCa full backupDa whole backup
单选题You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). On Server1, you have the following backup schedule: ·Normal backups every Saturday at 01:00 ·Differential backups every weekday at 02:00, except on Saturday You need to perform a complete manual backup of Server1 on Tuesday. The backup must not change which files are backed up during the next scheduled backup. Which type of backup should you perform? （）AcopyBdailyCincrementalDnormal
单选题Which type of backup contains only the blocks that have changed since the last level 0 incremental backup？（）A a cumulative level 1 backupB a differential level 1 backupC a full backupD a whole backup