题目内容

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

答案查题题库