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 

题目

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.
相似考题

1.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?（）A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B. RMAN reads the block change tracking file when it performs both incremental backups.C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D. RMAN does not read the block change tracking file when it performs either incremental backup.

2.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.

3. Server1 contains a folder named D:/Salesdata, which contains important company data. The hardware-monitoring software reports that the disk that contains volume D is in danger of imminent disk failure. You order a replacement disk, but you must wait at least one day for the disk to be delivered. You discover that you do not have a backup of the D:/Salesdata folder because a recent backup was configured incorrectly. You need to back up the D:/Salesdata folder so that you can restore the data if the disk fails. You need to achieve this goal as quickly as possible. What should you do? （）A、Perform a normal backup of the D:/Salesdata folder.B、Perform an incremental backup of the D:/Salesdata folder.C、Perform a differential backup of the D:/Salesdata folder.D、Perform a daily backup of the D:/Salesdata folder.E、Enable Shadow Copies on volume D:/Configure the shadow copy location as C:/.

4.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;

更多“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 ”相关问题

  • 第1题：

    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

  • 第2题：

    On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）

    • A、data files
    • B、control files
    • C、tablespaces
    • D、password file
    • E、parameter file
    • F、whole database
    • G、flashback log file
    • H、archived log files
    • I、change tracking file

    正确答案:A,C,F

  • 第3题：

    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.

    正确答案:B

  • 第4题：

    You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

    • A、 the system change number
    • B、 the locations of the redo log files
    • C、 the locations of the datafiles
    • D、 the physical location of all the database changes

    正确答案:D

  • 第5题：

    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?（）

    • A、RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
    • B、RMAN reads the block change tracking file when it performs both incremental backups.
    • C、RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
    • D、RMAN does not read the block change tracking file when it performs either incremental backup.

    正确答案:C

  • 第6题：

    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.

    正确答案:B

  • 第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

    正确答案:A

  • 第8题：

    单选题
    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;


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）
    A

     the system change number

    B

     the locations of the redo log files

    C

     the locations of the datafiles

    D

     the physical location of all the database changes


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）
    A

     The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.

    B

     The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.

    C

     The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.

    D

     The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第12题：

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

    C

     ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 

    D

     ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）

    • A、 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
    • B、 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
    • C、 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
    • D、 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

    正确答案:C

  • 第15题：

    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

  • 第16题：

    The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）

    • A、No transaction on the tablespace is allowed but you can perform queries.
    • B、The tablespace will automatically come out of backup mode when the file copy is complete.
    • C、The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
    • D、The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

    正确答案:A,C

  • 第17题：

    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.

    正确答案:B

  • 第18题：

    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
    • C、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
    • D、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

    正确答案:C

  • 第19题：

    You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

    • A、 You must configure OMF in your database.
    • B、 You must enable block change tracking feature in your database.
    • C、 You must enable ROW MOVEMENT feature on the ORDERS table.
    • D、 You must use the Flashback Version Query before using the Flashback Table feature.

    正确答案:C

  • 第20题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    多选题
    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,E
    解析： 暂无解析

  • 第22题：

    单选题
    You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）
    A

     You must configure OMF in your database.

    B

     You must enable block change tracking feature in your database.

    C

     You must enable ROW MOVEMENT feature on the ORDERS table.

    D

     You must use the Flashback Version Query before using the Flashback Table feature.


    正确答案： B
    解析： 暂无解析

  • 第23题：

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


    正确答案： B
    解析： 暂无解析

相关内容