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

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

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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

YouaremaintainingthePRODdatabaseofTeleSoftCorporation.YouhaveinitializedthefollowingDB_BLOCK_CHECKINGparameterintheinit.orafile:DB_BLOCK_CHECKING=TRUE;Whatwillbetheresultofsettingthisparameter?()

A.OnlydatablocksoftheSYSTEMtablespacewillbechecked.

B.OnlydatablocksoftheSYSAUXtablespacewillbechecked.

C.Achecksumwilloccuronlyonthecheckpoint.

D.Achecksumwilloccureverytimeablockismodified.


参考答案：D

第2题：

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.

正确答案:D

第3题：

You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? （）

A. Set the DB_SECUREFILE parameter to PERMITTED

B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY

C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL

D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL


参考答案：B

第4题：

You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）

  • A、 by using the DBMS_REPAIR package
  • B、 by using the DB_BLOCK_CHECKING parameter
  • C、 by using the DBVERIFY utility
  • D、 will not be completely resolved until the hardware fault is corrected

正确答案:D

第5题：

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

第6题：

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

第7题：

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 Oracle

正确答案:E

第8题：

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

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

更多相关问题
相关内容