单项选择题
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.
相关考题
-
单项选择题
YouareusingtheBlockMediaRecoveryfeaturetorecovertheblocksthataremarkedcorruptsincethelastbackup.Whichviewwillyouquerytodisplayinformationaboutthedatablocksthataremarkedcorruptsincethelastbackup？（）
A. V$BACKUP_CORRUPTION
B. V$COPY_CORRUPTION
C. V$DATABASE_BLOCK_CORRUPTION
D. RC_BACKUP_CORRUPTION -
单项选择题
YouaremaintainingyourOLTPdatabaseinOracle10g.YouareperformingtheFlashbackTransactionQuerytofindtheundoSQLstatementsthatcanbeusedtoundothechangesmadetothedatabaseinthespecifictimeperiod.WhichpseudocolumnwillyouusetoperformtheFlashbackTransactionQuery？（）
A. VERSIONS_STARTSCN
B. VERSIONS_STARTTIME
C. VERSIONS_XID
D. VERSIONS_OPERATION -
单项选择题
WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE；command？（）
A. The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are already in the Recycle Bin are dropped.
B. The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.
C. The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.
D. The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.
