ViewtheExhibittoobservetherolesassignedtotheSL_REPuser.WhichstatementistrueabouttheassignmentoftheSELECT_CATALOG_ROLEroletotheSL_REPuser()
A. Theusermustenabletheroleexplicitly.
B. Theusercangranttheroletootherusers.
C. TheusercannotusetheroleuntiltheDBAenablesitexplicitly.
D. Theusercanstartusingtheroleimmediatelywithoutanychanges
查看答案
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