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

题目

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

2.You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A、by using the ANALYZE utilityB、by using the DBVERIFY utilityC、by using the DB_BLOCK_CHECKING parameterD、by using the DBMS_REPAIR package

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

4.YouaremaintainingthePRODdatabaseofTeleSoftCorporation.YouhaveinitializedthefollowingDB_BLOCK_CHECKINGparameterintheinit.orafile:DB_BLOCK_CHECKING=TRUE;Whatwillbetheresultofsettingthisparameter?()A.OnlydatablocksoftheSYSTEMtablespacewillbechecked.B.OnlydatablocksoftheSYSAUXtablespacewillbechecked.C.Achecksumwilloccuronlyonthecheckpoint.D.Achecksumwilloccureverytimeablockismodified.

参考答案和解析
正确答案:E
更多“The DB_BLOCK_CHECKING̳”相关问题

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

    You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file：  DB_BLOCK_CHECKING = TRUE；  What will be the result of setting this parameter？（）

    • A、 Only data blocks of the SYSTEM tablespace will be checked.
    • B、 Only data blocks of the SYSAUX tablespace will be checked.
    • C、 A checksum will occur only on the checkpoint.
    • D、 A checksum will occur every time a block is modified.

    正确答案:D

  • 第3题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）
    A

    The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.

    B

    DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

    C

    The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.

    D

    The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.

    E

    The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent


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

  • 第4题：

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


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

  • 第5题：

    单选题
    You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）
    A

    by using the ANALYZE utility

    B

    by using the DBVERIFY utility

    C

    by using the DB_BLOCK_CHECKING parameter

    D

    by using the DBMS_REPAIR package


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

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


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

  • 第7题：

    The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

    • A、The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
    • B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
    • C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
    • D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
    • E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent

    正确答案:A

  • 第8题：

    You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes.   Which action will you perform to check the data blocks？（）

    • A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
    • B、 Use the ANALYZE utility.
    • C、 Use the DBVERIFY utility.
    • D、 Use the DBMS_REPAIR package.

    正确答案:A

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


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

  • 第10题：

    单选题
    You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file：  DB_BLOCK_CHECKING = TRUE；  What will be the result of setting this parameter？（）
    A

     Only data blocks of the SYSTEM tablespace will be checked.

    B

     Only data blocks of the SYSAUX tablespace will be checked.

    C

     A checksum will occur only on the checkpoint.

    D

     A checksum will occur every time a block is modified.


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

  • 第11题：

    单选题
    You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes.   Which action will you perform to check the data blocks？（）
    A

     Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE

    B

     Use the ANALYZE utility.

    C

     Use the DBVERIFY utility.

    D

     Use the DBMS_REPAIR package.


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

相关内容