TheDB_BLOCK_CHECKINGinitializationparameterissettoTRUE.Whatwouldbetheresultofthissettingonthedatablocksbeingwrittentothedatafiles,everytimetheDBWnwrites?()
A. TheOracledatabasewillcheckalldatablocksbygoingthroughthedataoneachblock,makingsurethedataisself-consistent.
B. DBWnandthedirectloaderwillcalculateachecksumandstoreitinthecacheheaderofeverydatablockwhenwritingittodisk.
C. TheOracledatabasewillcheckdatablocksbelongingtotheSYSTEMtablespaceonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.
D. TheOracledatabasewillcheckdatablocksbelongingtotheSYSAUXtablespaceonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.
E. TheOracledatabasewillcheckdatablocksintheSYSTEMandSYSAUXtablespacesonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent
查看答案
YouareusingRMANtobackupyourARCHIVELOGmodedatabase.Youhaveenabledcontrol-fileautobackups.WhichfilesarenotbackedupduringtheRMANbackup?()
A. DatabaseDatafiles
B. DatabaseControlFiles
C. Onlineredologs
D. Archivedredologs
E. ThedatabaseSPFILE
F. Noneoftheabove,allthesefilesarebackedup
Therewasmediafailureandyouneedtocheckthedatafilesforanyblockcorruption.Whichoptionwouldyouusetocreateareportonanycorruptionsfoundwithinthedatabase?()
A. theDBNEWIDutility
B. theDBVERIFYutility
C. theANALYZEcommand
D. theRMANREPORTcommand
E. theRMANCROSSCHECKcommand
F. theCHECK_OBJECTprocedureoftheDBMS_REPAIRpackage
HowwouldyougranttheRVPCuseraccesstospecificRMANdatabaserecordsintheRMANvirtualprivatecatalog?()
A. IssuethegrantcommandfromtheSYSuser(orequivalent)ofthetargetdatabase.
B. IssuethegrantcommandfromtheSYSuser(orequivalent)oftherecovery-catalogdatabase.
C. Issuethegrantcommandfromtherecoverycatalog-owningschemauseraccountintherecoverycatalog.
D. IssuethegrantcommandfromRMANwhenconnectedtotherecoverycatalog-owningschema.
E. IssuethegrantcommandfromRMANwhenconnectedtothetargetdatabase.
“群众是真正的英雄”一句话中,“群众”是()
A. 单独、集合概念
B. 单独、非集合概念
C. 普遍、集合概念
D. 普遍、非集合概念