OCP 11G认证考试

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

题目
多选题
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?()
A

The block change tracking data will be used only from the next incremental 0 backup.

B

The incremental backup will use change tracking data for accomplishing the backup.

C

The incremental backup will not use change tracking data for accomplishing the backup.

D

The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature?()

  • A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
  • B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
  • C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE 
  • D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 

正确答案:D

第2题:

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.

正确答案:A,D

第3题:

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?()

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;


参考答案:C

第4题:

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.

正确答案:B

第5题:

You are managing an Oracle Database 11g database with the following backup strategy:1) On Sunday, an incremental level 0 tape backup is performed.2) Monday through Saturday, a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed()

  • A、The backup performed in step 1 backs up all blocks that have ever been in use in the database.
  • B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
  • C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
  • D、The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

正确答案:A,B

第6题:

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()

  • A、Multiple change tracking files can be created for a database.
  • B、The change tracking file must be created after the first level 0 backup.
  • C、RMAN does not support backup and recovery of the change tracking file.
  • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

正确答案:C,D

第7题:

You are managing an Oracle Database 11g database with this backup strategy:  - Every Sunday night, level 0 backup is performed.  - On Monday night and subsequent days, level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true()

  • A、The backup contains all the used blocks.
  • B、The backup contains all the used and unused blocks.
  • C、The backup contains blocks that have changed since the last level 0 backup.
  • D、The backup contains blocks that have changed since the last level 1 backup taken last week.

正确答案:C

第8题:

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?()

  • A、Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  • B、The change tracking file must always be backed up when you perform a full database backup.
  • C、Block change tracking will always reduce I/O performed during cumulative incremental backups.
  • D、More than one database block may be read by an incremental backup for a change made to a single block.
  • E、The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

正确答案:B,C,E

第9题:

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?()

  • A、 The block change tracking data will be used only from the next incremental 0 backup.
  • B、 The incremental backup will use change tracking data for accomplishing the backup.
  • C、 The incremental backup will not use change tracking data for accomplishing the backup.
  • D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

正确答案:A,C

第10题:

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)

  • A、Multiple change tracking files can be created for a database.
  • B、The change tracking file must be created after the first level 0 backup.
  • C、RMAN does not support backup and recovery of the change tracking file.
  • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

正确答案:C,D

更多相关问题