WhichcommandsareusedforRMANdatabaserecovery?()
A. restore
B. repair
C. copy
D. recover
E. replace
查看答案
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.