题目内容

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.

答案查题题库