网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Amediafailurehasoccurred.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?()
A.Thedatabaseallowsonlyqueries;nootherstatementsareallowed.
B.Thedatabasere-createsthemissingredologfilesautomatically.
C.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.
D.Thedatabasereturnsanerrorandthedatabaseinstanceshutsdown.
E.Theusersessionsthatgenerateredologsareterminatedautomatically.
参考答案
更多 “ Amediafailurehasoccurred.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?() A.Thedatabaseallowsonlyqueries;nootherstatementsareallowed.B.Thedatabasere-createsthemissingredologfilesautomatically.C.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.D.Thedatabasereturnsanerrorandthedatabaseinstanceshutsdown.E.Theusersessionsthatgenerateredologsareterminatedautomatically. ” 相关考题
考题
Inyourdatabase,theLogWriter(LGWR)processisunabletowritetoamemberofacurrentredologgroupduetoread/writefailure.Whichtwoeffectswouldyouseeinyourdatabase?()
A.Thedatabaseinstanceaborts.B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
考题
Whichtwostatementsaboutthebackgroundprocessofthedatabasewriteraretrue()
A.ItispossibletohavemultipledatabasewritersinanOracleinstance.B.Itwritesdirtybuffers,ifany,todatafileswheneveracheckpointoccurs.C.Itwritesdirtybuffers,ifany,todatafileswheneveratransactioncommits.D.Itwritesdirtybuffers,ifany,todatafilesbeforethelogwriter(LGWR)writes
考题
WhichbackgroundprocesssequentiallywritesFlashbackDatabasedatafromtheflashbackbuffertotheFlashbackDatabaselogs?()
A.DBWnB.RECOC.RVWRD.LGWR
考题
Amediafailurehasoccurred.Thishasresultedinallthemembersofthenexthoploggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?()
A.Thedatabasere-createdthemissingredologfilesautomatically.B.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.C.Thedatabaseallowsonlyqueries,nootherstatementsareallowed.D.Thedatabasereturnsanderrorandthedatabaseinstanceshutsdown.E.Theusersessionsthatgenerateredologsareterminatedautomatically.
考题
TheLogWriter(LGWR)processreadsinformationfromthe()andwritesittotheonlinelogs.
A.largepoolB.sharedpoolC.databuffercacheD.redologbufferE.datadictionarycache
考题
哪个后台进程负责清理出现故障的进程?A.PMONB.SMONC.DBWRD.LGWR
热门标签
最新试卷