单项选择题
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
相关考题
-
单项选择题
TheEMPLOYEEStableisstoredintheUSERStablespace.YouneedtocheckiftheEMPLOYEEStableisaffectedbytheblockcorruptionfoundintheUSERStablespace.Whichoptionwouldyouuse?()
A.the DBNEWID utility
B.the ANALYZE command
C.the RMAN LIST command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the RMAN BLOCKRECOVER command -
单项选择题
Therewasmediafailureandyouneedtocheckthedatafilesforanyblockcorruption.Whichoptionwouldyouusetocreateareportonanycorruptionsfoundwithinthedatabase?()
A.the DBNEWID utility
B.the DBVERIFY utility
C.the ANALYZE command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the CHECK_OBJECT procedure of the DBMS_REPAIR package -
单项选择题
Byusingthetransactionidentifierprovidedby()foraparticularrowchange,youcanusetheFlashbackTransactionQuerytoseetheoperationperformedbythetransaction.
A.Flashback Table
B.Flashback Database
C.Flashback Versions Query
D.the RMAN REPORT command
E.the DBA_PENDING_TRANSACTIONS view
