违法和不良信息举报 联系客服
免费注册 登录

You need to perform a block med

题目

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
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

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

第3题：

Dear friend, whenever you need help,().

A. count me out

B. count in me

C. count out me

D. count me in


参考答案：D

第4题：

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

第5题：

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

第6题：

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

第7题：

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

第8题：

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


参考答案：C, D

第9题：

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

第10题：

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

更多相关问题
相关内容