单选题What purpose would you achieve by enabling the block change tracking feature？（）AEliminate the necessity for backups.BPerform optimized image copy backups.CPerform optimized incremental backups.DEnable checkpoint （CKPT） to perform checkpointing at every

题目
单选题
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.(b) What styles of managing change would you recommend John use to bring about the desired change?(8 marks)

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

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

4.A:( ), David? B:An orange juice.A. What do you likeB. What would you likeC. Would you like an orange juice

更多“What purpose would you achieve by enabling the block change ”相关问题

  • 第1题：

    If there were two things you could change in your last (or present) job, what would they be and how would you change them?

    如果在你的前一份（或现在的）工作中，你可以改变两件事，会是什么，你如何改变？


    正确答案：

     

     

  • 第2题：

    The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  

    • A、 The block change tracking feature must be enabled.
    • B、 OMF must be configured on your database.
    • C、 The database must be in ARCHIVELOG mode.
    • D、 A USERID must be supplied.

    正确答案:D

  • 第3题：

    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

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

  • 第6题：

    You manage a server that runs Windows Server 2008. You have installed the Windows SharePointServices （WSS） server role on the server. The server is configured to accept incoming mail. Tostreamline the process， you create a new document library. You have to make sure that any user can sendemail to the document library. What should you do to achieve this task？（）

    • A、Change the incoming email settings for the document library
    • B、Enable basic user authentication for the document library
    • C、Modify the document library settings to accept emails from SMTP servers
    • D、Change the permissions for the document library

    正确答案:A

  • 第7题：

    单选题
    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
    解析： 暂无解析

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

    C

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

    D

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第9题：

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


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

  • 第10题：

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


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

  • 第11题：

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


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

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

    Which of the following statements is NOT true about RMAN？（）

    • A、It improves usability by enabling you to reuse the scripts to perform recovery operations.
    • B、It detects block corruption while restoration and recovery operations.
    • C、It enables you to perform block media recovery.
    • D、It is capable to recover through unrecoverable operations， with only full database backups.

    正确答案:A

  • 第14题：

    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.

    正确答案:C

  • 第15题：

    Which RMAN backup command is used to create the block-change tracking file？（）  

    • A、 alter database create block change tracking file
    • B、 alter database enable block change file
    • C、 alter database enable block change tracking using file ，/ora01/opt/ block_change_tracking.fil
    • D、 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
    • E、 alter system block change tracking on

    正确答案:C

  • 第16题：

    What is the purpose of the until change option of the restore command？（）  

    • A、 It allows you to select the SCN that you want to restore to.
    • B、 It allows you to select the log sequence number you want to restore to.
    • C、 It allows you to select the timestamp you want to restore to.
    • D、 It allows you to manually stop the restore at any time as online redo logs are applied.
    • E、 None of the above.

    正确答案:A

  • 第17题：

    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

    • A、 recover lost blocks
    • B、 recover corrupt blocks
    • C、 recover media corrupt blocks from list
    • D、 recover corrupt blocks from list
    • E、 recover corruption list

    正确答案:E

  • 第18题：

    单选题
    What is the purpose of the until change option of the restore command？（）
    A

     It allows you to select the SCN that you want to restore to.

    B

     It allows you to select the log sequence number you want to restore to.

    C

     It allows you to select the timestamp you want to restore to.

    D

     It allows you to manually stop the restore at any time as online redo logs are applied.

    E

     None of the above.


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

  • 第19题：

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


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

  • 第20题：

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

  • 第21题：

    单选题
    You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）
    A

     One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.

    B

     One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.

    C

     One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.

    D

     One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.


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

  • 第22题：

    单选题
    You want a record of all queries that are not using indexes. How would you achieve this?（）
    A

    By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically

    B

    By enabling the Error Log because not using indexes is an error

    C

    By enabling the Slow Query Log and using the – log-queries-not-using-indexes option

    D

    By enabling the Error Log and using the – log-queries-not-using-indexes option


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

  • 第23题：

    单选题
    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
    A

     recover lost blocks

    B

     recover corrupt blocks

    C

     recover media corrupt blocks from list

    D

     recover corrupt blocks from list

    E

     recover corruption list


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

  • 第24题：

    单选题
    The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）
    A

     The block change tracking feature must be enabled.

    B

     OMF must be configured on your database.

    C

     The database must be in ARCHIVELOG mode.

    D

     A USERID must be supplied.


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

相关内容