单选题How is block-change tracking enabled?（）A With alter database enable block change trackingB With alter system enable block change tracking C With an init.ora parameter change D With an spfile parameter change 

题目
单选题
How is block-change tracking enabled?（）
A

With alter database enable block change tracking

B

With alter system enable block change tracking 

C

With an init.ora parameter change 

D

With an spfile parameter change 

相似考题

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

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

4.How is block-change tracking enabled?（）A、With alter database enable block change trackingB、With alter system enable block change tracking C、With an init.ora parameter change D、With an spfile parameter change 

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题How is block-change tracking enabled?（）A With alter database enable block change trackingB With alter system enable block change tracking C With an init.ora parameter change D With an spfile parameter change”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

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


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

  • 第7题：

    单选题
    Which dynamic view displays the status of block-change tracking?（）
    A

    V$BLOCK_CHANGE 

    B

    V$BLOCK_CHANGE_TRACKING 

    C

    V$BLOCKCHANGE 

    D

    V$BLOCK_TRACKING


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

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

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

  • 第10题：

    单选题
    How is block-change tracking enabled？（）
    A

     With alter database enable block change tracking

    B

     With alter system enable block change tracking

    C

     With an init.ora parameter change

    D

     With an spfile parameter change


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

  • 第11题：

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


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    How is block-change tracking enabled？（）  

    • A、 With alter database enable block change tracking
    • B、 With alter system enable block change tracking
    • C、 With an init.ora parameter change
    • D、 With an spfile parameter change

    正确答案:A

  • 第15题：

    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

  • 第16题：

    Which dynamic view displays the status of block-change tracking?（）

    • A、V$BLOCK_CHANGE 
    • B、V$BLOCK_CHANGE_TRACKING 
    • C、V$BLOCKCHANGE 
    • D、V$BLOCK_TRACKING

    正确答案:B

  • 第17题：

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

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


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

  • 第19题：

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

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

    单选题
    How is block-change tracking enabled?（）
    A

    With alter database enable block change tracking

    B

    With alter system enable block change tracking 

    C

    With an init.ora parameter change 

    D

    With an spfile parameter change 


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

  • 第22题：

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


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

  • 第23题：

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


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

  • 第24题：

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

相关内容