单项选择题

YoudroppedaschemaofauserinanOracle10gbymistake.Youdecidetoflashthedatabasebacktoitspreviousstatetorestorethedeletedschema.Whichprocesswritesthebeforeimagesofthephysicaldatabaseblockstotheflashbackdatabaselogs？（）
A.LGWR
B.DBWR
C.MMON
D.RVWR

A.Youdecidetoflashthedatabasebacktoitspreviousstatetorestorethedeletedschema.Whichprocesswritesthebeforeimagesofthephysicaldatabaseblockstotheflashbackdatabaselogs？（）
A.LGWR
B.DBWR
C.MMON
D.RVWR
<上一题 目录 下一题>
热门 试题

未分类题
YouneedtoreviewthecurrentstoragesystemanddecideonthebestconfigurationforthetempdbdatabaseonSQL1toimprovetempdbperformance.Yoursolutionmustensurethatcompanyrequirementsandpoliciesarefulfilled.Whichtwoactionsshouldyouperform？（）A.CreateaRAID-1set，andmovetempdbtothisdriveset.B.CreateaRAID-0set，andmovetempdbtothisdriveset.C.Setthestartingsizeoftempdbto3GBD.CreateaRAID-0set，andmovetempdbandtheuserdatabasewiththelargestindextothisdriveset.E.Disableautomaticfilegrowthontempdb.
单项选择题
TheHRusercreatesaviewwiththiscommand：SQL>CREATEVIEWemp_vASSELECT*FROMscott.emp；NowHRwantstogranttheSELECTprivilegeontheEMP_VviewtotheJIMuser.Whichstatementistrueinthisscenario？（）
A.HRcangranttheprivilegetoJIMbutwithoutGRANTOPTION.
B.HRcangranttheprivilegetoJIMbecauseHRistheowneroftheview.
C.SCOTThastogranttheSELECTprivilegeontheEMPtabletoJIMbeforethisoperation.
D.HRneedstheSELECTprivilegeontheEMPtablewithGRANTOPTIONfromSCOTTforthisoperation.
相关试题