问答题

WhilecreatingaschedulerwindowusingtheDBMS_SCHEDULERpackage，auserloggedinasDBMGRgetstheerrormessageinsufficientprivileges.Whichtwocommandswouldyouusetoresolvethiserror？（）

A.GRANTdbaTOdbmgr
B.GRANTconnectTOdbmgr
C.GRANTresourceTOdbmgr
D.GRANThs_admin_roleTOdbmgr
E.GRANTmanageschedulerTOdbmgr

你可能感兴趣的试题

AnRMANbackupjobfails，displayingthefollowingerror：ORA19809：limitexceededforrecoveryfilesYouranalysisshowsthattheFlashRecoveryareaisfull.Whichtwoactionscouldyoutaketoresolvetheerrorandavoidthiserrorinfuture？（）
A.takethebackupoftheflashrecoveryarealessfrequently
B.increasethevalueoftheUNDO_RETENTIONinitializationparameter
C.changethevalueoftheWORKAREA_SIZE_POLICYinitializationparametertoAUTO
D.changethebackupretentionpolicytoretainthebackupsforasmallerperiodoftime
E.increasethevalueoftheDB_RECOVERY_FILE_DEST_SIZEinitializationparameter
F.increasethevalueoftheCONTROL_FILE_RECORD_KEEP_TIMEinitializationparameter

A.Whichtwoactionscouldyoutaketoresolvetheerrorandavoidthiserrorinfuture？（）
A.takethebackupoftheflashrecoveryarealessfrequently
B.increasethevalueoftheUNDO_RETENTIONinitializationparameter
C.changethevalueoftheWORKAREA_SIZE_POLICYinitializationparametertoAUTO
D.changethebackupretentionpolicytoretainthebackupsforasmallerperiodoftime
E.increasethevalueoftheDB_RECOVERY_FILE_DEST_SIZEinitializationparameter
F.increasethevalueoftheCONTROL_FILE_RECORD_KEEP_TIMEinitializationparameter

InRecoveryManager（RMAN），youhavesetcontrolfileautobackuptoONbyusingthefollowingcommand：CONFIGURECONTROLFILEAUTOBACKUPONWhichtwoeventswouldcausethecontrolfiletobebackedupautomatically？（）

A.atablespaceistakenoffline
B.thedatabaseinstanceisrestarted
C.anewdatafileisaddedtoanexistingtablespace
D.asuccessfulbackupisrecordedintheRMANrepository
E.theRMANconnectionisdisconnectedfromthetargetdatabase