多选题Which three activities are supported by the Data Recovery Advisor?()AAdvising on block checksum failuresBAdvising on inaccessible control filesCAdvising on inaccessible block change tracking filesDAdvising on empty password filesEAdvising on invalid bl

题目
多选题
Which three activities are supported by the Data Recovery Advisor?()
A

Advising on block checksum failures

B

Advising on inaccessible control files

C

Advising on inaccessible block change tracking files

D

Advising on empty password files

E

Advising on invalid block header field values


相似考题
更多“多选题Which three activities are supported by the Data Recovery Advisor?()AAdvising on block checksum failuresBAdvising on inaccessible control filesCAdvising on inaccessible block change tracking filesDAdvising on empty password filesEAdvising on invalid bl”相关问题
  • 第1题:

    Which three types of content filtering are supported only for HTTP? ()(Choose three.)

    • A、block Flash
    • B、block Java applets
    • C、block ActiveX
    • D、block EXE files
    • E、block MIME type

    正确答案:B,C,D

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

    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 file
    • B、You must have first level 1 backups for RMAN to restore blocks
    • C、You must ensure that the SALES database is mounted or open
    • D、You must have full or level 0 backups for RMAN to restore blocks
    • E、You must take the tools01.dbf data file offline before you start a block media recovery

    正确答案:C,D

  • 第4题:

    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

  • 第5题:

    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

  • 第6题:

    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.

    正确答案:C

  • 第7题:

    Which three activities are supported by the Data Recovery Advisor?()

    • A、Advising on block checksum failures
    • B、Advising on inaccessible control files
    • C、Advising on inaccessible block change tracking files
    • D、Advising on empty password files
    • E、Advising on invalid block header field values

    正确答案:A,B,E

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

    多选题
    Which three activities are supported by the Data Recovery Advisor?()
    A

    Advising on block checksum failures

    B

    Advising on inaccessible control files

    C

    Advising on inaccessible block change tracking files

    D

    Advising on empty password files

    E

    Advising on invalid block header field values


    正确答案: A,E
    解析: 暂无解析

  • 第10题:

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

  • 第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?()
    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
    解析: 暂无解析

  • 第12题:

    单选题
    You received the following error:   ORA-01578: ORACLE data block corrupted   (file # %s, block # %s)   Which file will you check to view additional information regarding the cause of this error?()
    A

    the alert log file and the trace files

    B

     the redo log files

    C

     the control file

    D

     the change tracking file


    正确答案: 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题:

    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

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

    You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario?()

    • A、 You must ensure that the SALES database is mounted or open.
    • B、 You must restore a backup control file to perform a block media recovery.
    • C、 You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、 You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

    正确答案:A,E

  • 第17题:

    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

  • 第18题:

    You received the following error:   ORA-01578: ORACLE data block corrupted   (file # %s, block # %s)   Which file will you check to view additional information regarding the cause of this error?()

    • A、the alert log file and the trace files
    • B、 the redo log files
    • C、 the control file
    • D、 the change tracking file

    正确答案:A

  • 第19题:

    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

  • 第20题:

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

  • 第21题:

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

    B

    You must have first level 1 backups for RMAN to restore blocks

    C

    You must ensure that the SALES database is mounted or open

    D

    You must have full or level 0 backups for RMAN to restore blocks

    E

    You must take the tools01.dbf data file offline before you start a block media recovery


    正确答案: B,E
    解析: 暂无解析

  • 第22题:

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

  • 第23题:

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

  • 第24题:

    多选题
    You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario?()
    A

    You must ensure that the SALES database is mounted or open.

    B

    You must restore a backup control file to perform a block media recovery.

    C

    You must take the tools01.dbf data file offline before you start a block media recovery.

    D

    You must put the database in NOARCHIVELOG mode to perform a block media recovery.

    E

    You can perform only a complete media recovery of individual blocks; point-in-time recovery of  individual data blocks is not supported.


    正确答案: C,E
    解析: 暂无解析