网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
Amediafailurehasoccurred.Thishasresultedinallthemembersofthenexthoploggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?()

A.Thedatabasere-createdthemissingredologfilesautomatically.

B.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.

C.Thedatabaseallowsonlyqueries,nootherstatementsareallowed.

D.Thedatabasereturnsanderrorandthedatabaseinstanceshutsdown.

E.Theusersessionsthatgenerateredologsareterminatedautomatically.


参考答案

更多 “ Amediafailurehasoccurred.Thishasresultedinallthemembersofthenexthoploggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?() A.Thedatabasere-createdthemissingredologfilesautomatically.B.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.C.Thedatabaseallowsonlyqueries,nootherstatementsareallowed.D.Thedatabasereturnsanderrorandthedatabaseinstanceshutsdown.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.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?() A.Thedatabaseallowsonlyqueries;nootherstatementsareallowed.B.Thedatabasere-createsthemissingredologfilesautomatically.C.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.D.Thedatabasereturnsanerrorandthedatabaseinstanceshutsdown.E.Theusersessionsthatgenerateredologsareterminatedautomatically.

考题 动态注册中,在LISTENER启动时向其注册数据库服务的是哪个后台进程?() A. SMONB. PMONC. CKPTD. LGWR

考题 TheLogWriter(LGWR)processreadsinformationfromthe()andwritesittotheonlinelogs. A.largepoolB.sharedpoolC.databuffercacheD.redologbufferE.datadictionarycache

考题 ()进程主要职责是监控服务器进程和注册数据库服务。 A.SMONB.PMONC.CHKTD.LGWR

考题 LGWR以()方式写入重做日志文件。A.循环B.顺序C.随机D.跳跃

考题 哪个后台进程负责清理出现故障的进程?A.PMONB.SMONC.DBWRD.LGWR