单项选择题
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.
相关考题
-
单项选择题
YouworkasadatabaseadministratoratCertkiller.com.YourproductiondatabaseusesanAutomaticStorageManagement（ASM）instancetomanageitsfiles.YouwanttoaddanewdiskgrouptotheASMinstancetomanagetheincreaseddataload.WhatactionwouldyouperformtoincludethenewdiskgroupintheASMinstancewithoutcausinganyimpactonthecurrentlyconnectedusers？（）
A. mount the new disk group in the ASM instance
B. restart the ASM instance and the production database instance
C. register the new disk groups in the production database instance
D. restart the ASM instance without restarting the production database instance
E. include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance -
单项选择题
Exhibit， One of the important tables in the USERStablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）
A. You must recover all data files to the required system change number （SCN）.
B. You must recover all data files， except those that are offline， to the required SCN.
C. You must recover all data files belonging to the USERS tablespace to the required SCN.
D. You cannot recover all data files because segment space management is performed manually for the undo tablespace. -
单项选择题
Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindex-organized（IOT）.YouwanttocreateabitmapindexontheJOD_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
A. A primary key must have been created.
B. A mapping table must have been created.
C. An overflow tablespace must have been specified.
D. The PCTTHRESHOLD option must have been specified.
