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 fileB、You

题目

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

1.Dear friend, whenever you need help,().A. count me outB. count in meC. count out meD. count me in

2.The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?()A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle database will perform block checking for the default permanent tablespace onlyD. The Oracle database will perform block checking for the data blocks in all user tablespacesE. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

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 fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

4.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?()A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

更多“You need to perform a block med”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）  

    • A、 RECOVER FILE=1201 BLOCK=1968
    • B、 RECOVER CORRUPTION LIST
    • C、 RECOVER DATAFILE 1201 BLOCK 1968
    • D、 RECOVER BLOCK CORRUPTION LIST
    • E、 None of the above

    正确答案:B,C

  • 第4题：

    The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）

    • A、 DB_4K_CACHE_SIZE only
    • B、 DB_8K_CACHE_SIZE only
    • C、 DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
    • D、 DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
    • E、 SGA_TARGET and DB_4K_CACHE_SIZE
    • F、 DB_CACHE_SIZE only

    正确答案:A

  • 第5题：

    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.

    正确答案:A,E

  • 第6题：

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

  • 第7题：

    单选题
    The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）
    A

     DB_4K_CACHE_SIZE only

    B

     DB_8K_CACHE_SIZE only

    C

     DB_BLOCK_SIZE and DB_4K_CACHE_SIZE

    D

     DB_BLOCK_SIZE and DB_8K_CACHE_SIZE

    E

     SGA_TARGET and DB_4K_CACHE_SIZE

    F

     DB_CACHE_SIZE only


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

  • 第8题：

    单选题
    You need to rename a data file of a tablespace. How would you perform this？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第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 need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


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

  • 第11题：

    单选题
    You need to block messages from senders that do not comply sender policy framework （SPF）.What do you need to implement？（）
    A

    Receive connector

    B

    Sender ID Filtering

    C

    Sender Filtering

    D

    Send connector


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

  • 第12题：

    多选题
    Your company has an Active Directory Domain Services (AD DS) domain. All servers run Windows Server 2008 R2. All client computers run Windows 7. Your environment includes Microsoft Enterprise Desktop Virtualization (MED-V). You use MED-V to support temporary test environments. You need to ensure that the disk space used by obsolete Workspaces is automatically minimized. Which two actions should you perform?（）
    A

    Configure the Workspace as revertible.

    B

    Set an expiration date for the Workspace.

    C

    Specify the number of image versions to keep.

    D

    Configure automatic deletion of the Workspace.


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

  • 第13题：

    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）

    • A、 The Oracle database will not perform block checking for any of the data blocks.
    • B、 The Oracle database will perform block checking for the default permanent tablespace only. 
    • C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.
    • D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

    正确答案:D

  • 第14题：

    The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

    • A、 The Oracle database will perform block checking for the index blocks only
    • B、 The Oracle database will not perform block checking for any of the data blocks
    • C、 The Oracle database will perform block checking for the default permanent tablespace only
    • D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

    正确答案:E

  • 第15题：

    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

  • 第16题：

    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

    • A、 You do not need to restore all the data files.
    • B、 You do not need to open the database with the RESETLOGS operation
    • C、 You do not need to perform a full backup after the RESETLOGS operation.
    • D、 You do not need to recover all the data files to the same system change number （SCN）.

    正确答案:C

  • 第17题：

    You have an Exchange Server 2010 organization that contains multiple Hub Transport servers. You need to recommend a message hygiene solution to meet the following requirements： .Block servers that are known to send spam .Minimize administrative effort What should you recommend？（）

    • A、an IP Block list
    • B、IP Block list providers
    • C、recipient filtering
    • D、sender filtering

    正确答案:B

  • 第18题：

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


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

  • 第19题：

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

  • 第20题：

    多选题
    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）
    A

    RECOVER FILE=1201 BLOCK=1968

    B

    RECOVER CORRUPTION LIST

    C

    RECOVER DATAFILE 1201 BLOCK 1968

    D

    RECOVER BLOCK CORRUPTION LIST

    E

    None of the above


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

  • 第21题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）
    A

     The Oracle database will perform block checking for the index blocks only

    B

     The Oracle database will not perform block checking for any of the data blocks

    C

     The Oracle database will perform block checking for the default permanent tablespace only

    D

     The Oracle database will perform block checking for the data blocks in all user tablespaces

    E

     The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only


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

  • 第22题：

    多选题
    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？（）
    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


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

  • 第23题：

    单选题
    While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）
    A

     Block Media Recovery must be used with RMAN.

    B

     You must perform complete recovery of individual blocks.

    C

     You must have a full RMAN backup， not an incremental backup.

    D

     You must use the DBVERIFY utility before using the Block Media Recovery feature.


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

相关内容