单选题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
题目
Set the DB_SECUREFILE parameter to PERMITTED
Set the DB_ULTRA_SAFE parameter to DATA_ONLY
Set the DB_LOCK_CHECKSUM parameter to TYPICAL
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
相似考题
更多“单选题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”相关问题
-
第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题：
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 -
第3题：
Examine the following command used to perform incremental level 0 backup： RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE； To enable the block change tracking， after the incremental level 0 backup you issued the following command： SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command： RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE； Which two statements are true in the above situation？（）
- A、 The block change tracking data will be used only from the next incremental 0 backup.
- B、 The incremental backup will use change tracking data for accomplishing the backup.
- C、 The incremental backup will not use change tracking data for accomplishing the backup.
- D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
正确答案:A,C -
第4题：
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 -
第5题：
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 -
第6题：
单选题You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）ACreate the relation manually and coordinate the blocks using triggers.
BBase the relation on a REF pointer using the Data Block Wizard.
CBase the relation on a foreign key using the Data Block Wizard.
DThis task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
正确答案： A解析： 暂无解析 -
第7题：
单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）AALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
BALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
正确答案： D解析： 暂无解析 -
第8题：
单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）AALTER DATABASE ENABLE BLOCK CHANGE TRACKING
BALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
正确答案： D解析： 暂无解析 -
第9题：
单选题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？（）ASet the DB_SECUREFILE parameter to PERMITTED
BSet the DB_ULTRA_SAFE parameter to DATA_ONLY
CSet the DB_LOCK_CHECKSUM parameter to TYPICAL
DSet the DB_LOST_WRITE_PROTECT parameter to TYPICAL
正确答案： A解析： 暂无解析 -
第10题：
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）Acreate a backup of the database and recover all corrupted blocks found in the backup
Brun a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
Crun a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
Drun a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
Erun 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解析： 暂无解析 -
第11题：
单选题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？（）AThe block change tracking feature must be enabled.
BOMF must be configured on your database.
CThe database must be in ARCHIVELOG mode.
DA USERID must be supplied.
正确答案： C解析： 暂无解析 -
第12题：
单选题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？（）AThe Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
BDBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
CThe 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.
DThe 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.
EThe 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解析： 暂无解析 -
第13题：
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）
- A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
- B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
- C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
； - D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
；
正确答案:D -
第14题：
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 -
第15题：
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 -
第16题：
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）
- A、RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
- B、RMAN reads the block change tracking file when it performs both incremental backups.
- C、RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
- D、RMAN does not read the block change tracking file when it performs either incremental backup.
正确答案:C -
第17题：
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 -
第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？（）AOnly data blocks of the SYSTEM tablespace will be checked.
BOnly data blocks of the SYSAUX tablespace will be checked.
CA checksum will occur only on the checkpoint.
DA 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？（）ACreate a backup of the database and recover all corrupted blocks found in the backup.
BRun a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
CRun a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
DRun a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
ERun 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题：
单选题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？（）ABlock Media Recovery must be used with RMAN.
BYou must perform complete recovery of individual blocks.
CYou must have a full RMAN backup， not an incremental backup.
DYou must use the DBVERIFY utility before using the Block Media Recovery feature.
正确答案： D解析： 暂无解析 -
第21题：
单选题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?（）AUse the Data Block Wizard and base the relation on a REF pointer.
BIn 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.
CUse the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database.
DThis task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
正确答案： D解析： 暂无解析 -
第22题：
多选题Which of the following are correct about block media recovery？（）APhysical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
BLogical corruptions are repairable by BMR
CPhysical corruptions are repairable by BMR
DRMAN can use any backup for a BMR restore
EARCHIVELOG mode is not required if you have both a full and incremental backup for restore
正确答案： A,C解析： 暂无解析 -
第23题：
单选题You enable block change tracking. You issue the following command： BACKUP INCREMENTAL LEVEL 0 DATABASE； The next day，you issue the following command： BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE； Which statement about the use of the change tracking file is true？（）ARMAN reads the block change tracking file only when it performs the incremental level 0 backup.
BRMAN reads the block change tracking file when it performs both incremental backups.
CRMAN reads the block change tracking file only when it performs the incremental level 1 backup.
DRMAN does not read the block change tracking file when it performs either incremental backup.
正确答案： C解析： 暂无解析