niusouti.com

单选题You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change. 

题目
单选题
You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  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

相似考题

1.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 PERMITTEDB. Set the DB_ULTRA_SAFE parameter to DATA_ONLYC. Set the DB_LOCK_CHECKSUM parameter to TYPICALD. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

2.You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION

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

4. The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  A、 The block change tracking feature must be enabled.B、 OMF must be configured on your database.C、 The database must be in ARCHIVELOG mode.D、 A USERID must be supplied.

更多“单选题You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  ”相关问题

  • 第1题：

    You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  

    • A、 Repair the corrupted blocks. If any. In the backup created
    • B、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
    • C、 Back up the database after checking whether array of the files have corrupted blocks
    • D、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
    • E、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

    正确答案:B,C

  • 第2题：

    Which of the following are correct about block media recovery？（）

    • A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
    • B、 Logical corruptions are repairable by BMR
    • C、 Physical corruptions are repairable by BMR
    • D、 RMAN can use any backup for a BMR restore
    • E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

    正确答案:A,C

  • 第3题：

    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

    • A、create a backup of the database and recover all corrupted blocks found in the backup
    • B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
    • C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
    • D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
    • E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

    正确答案:D

  • 第4题：

    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

  • 第5题：

    You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  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

  • 第6题：

    单选题
    You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）
    A

    Create the relation manually and coordinate the blocks using triggers. 

    B

    Base the relation on a REF pointer using the Data Block Wizard. 

    C

    Base the relation on a foreign key using the Data Block Wizard. 

    D

    This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.


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

  • 第7题：

    单选题
    In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）
    A

    The modified blocks would be written to the data files.

    B

    The modified blocks would be written to the temp files.

    C

    The modified blocks would be written to the control file.

    D

    The modified blocks would be written to the redo log files.

    E

    The modified blocks would be written to the archived redo log files.

    F

    The modified blocks would be retained in the database buffer cache.


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

  • 第8题：

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

  • 第9题：

    单选题
    he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）
    A

    Use the Data Block Wizard and base the relation on a REF pointer. 

    B

    In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.

    C

    Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. 

    D

    This task is not possible because master-detail relations can be implemented only for blocks based on relational tables. 


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

  • 第10题：

    多选题
    Which of the following are correct about block media recovery？（）
    A

    Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION

    B

    Logical corruptions are repairable by BMR

    C

    Physical corruptions are repairable by BMR

    D

    RMAN can use any backup for a BMR restore

    E

    ARCHIVELOG mode is not required if you have both a full and incremental backup for restore


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

  • 第11题：

    单选题
    You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）
    A

     V$BACKUP_CORRUPTION

    B

     V$COPY_CORRUPTION

    C

     V$DATABASE_BLOCK_CORRUPTION

    D

     RC_BACKUP_CORRUPTION


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

  • 第12题：

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

  • 第13题：

    he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）

    • A、Use the Data Block Wizard and base the relation on a REF pointer. 
    • B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
    • C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. 
    • D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables. 

    正确答案:A

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

    • A、 Create a backup of the database and recover all corrupted blocks found in the backup.
    • B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
    • C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
    • D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
    • E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

    正确答案:D

  • 第17题：

    You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）

    • A、Create the relation manually and coordinate the blocks using triggers. 
    • B、Base the relation on a REF pointer using the Data Block Wizard. 
    • C、Base the relation on a foreign key using the Data Block Wizard. 
    • D、This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.

    正确答案:B

  • 第18题：

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

  • 第19题：

    单选题
    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）
    A

     Create a backup of the database and recover all corrupted blocks found in the backup.

    B

     Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

    C

     Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.

    D

     Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.

    E

     Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.


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

  • 第20题：

    单选题
    You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  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


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

  • 第21题：

    单选题
    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）
    A

    create a backup of the database and recover all corrupted blocks found in the backup

    B

    run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database

    C

    run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view

    D

    run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view

    E

    run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired


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

  • 第22题：

    单选题
    The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）
    A

     The block change tracking feature must be enabled.

    B

     OMF must be configured on your database.

    C

     The database must be in ARCHIVELOG mode.

    D

     A USERID must be supplied.


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

  • 第23题：

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


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

  • 第24题：

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


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

相关内容