网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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
考题
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
考题
YouaremaintainingthePRODdatabaseofTeleSoftCorporation.YouhaveinitializedthefollowingDB_BLOCK_CHECKINGparameterintheinit.orafile:DB_BLOCK_CHECKING=TRUE;Whatwillbetheresultofsettingthisparameter?()
A.OnlydatablocksoftheSYSTEMtablespacewillbechecked.B.OnlydatablocksoftheSYSAUXtablespacewillbechecked.C.Achecksumwilloccuronlyonthecheckpoint.D.Achecksumwilloccureverytimeablockismodified.
考题
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.
考题
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.
考题
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
考题
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
考题
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
考题
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 packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected
考题
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.
考题
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
考题
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.
考题
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 TRUEB、 Use the ANALYZE utility.C、 Use the DBVERIFY utility.D、 Use the DBMS_REPAIR package.
考题
The DB_BLOCK_CHECKINGinitialization 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、 The 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.
考题
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 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
考题
单选题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.
考题
单选题The DB_BLOCK_CHECKINGinitialization 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
The 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.
考题
单选题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.
考题
单选题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 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
考题
单选题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 packageB
by using the DB_BLOCK_CHECKING parameterC
by using the DBVERIFY utilityD
will not be completely resolved until the hardware fault is corrected
考题
单选题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.
考题
单选题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 TRUEB
Use the ANALYZE utility.C
Use the DBVERIFY utility.D
Use the DBMS_REPAIR package.
考题
单选题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
考题
单选题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
考题
单选题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
考题
单选题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
考题
多选题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？（）AYou must ensure that the SALES database is mounted or open.BYou must restore a backup control file to perform a block media recovery.CYou must take the tools01.dbf data file offline before you start a block media recovery.DYou must put the database in NOARCHIVELOG mode to perform a block media recovery.EYou can perform only a complete media recovery of individual blocks； point-in-time recovery of individual data blocks is not supported.
热门标签
最新试卷