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

题目内容 (请给出正确答案)
YouworkasadatabaseadministratorforSupportcenter.cn.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA-01555:snapshottooold,Inwhichsituationwouldyoureceivesuchanerror?()

A.Youperformedrollbackaftercommit.

B.Ifalogswitchoccursinyourdatabase.

C.Thearchiverfailstogenerateanarchivedlogfile.

D.Instancerecoveryfailstofindoneoftheredologfiles.

E.Along-runningqueryisunabletogetread-consistentimage.

F.Ifyouperformmanualundomanagementoperationsinautomode.


参考答案

更多 “ YouworkasadatabaseadministratorforSupportcenter.cn.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA-01555:snapshottooold,Inwhichsituationwouldyoureceivesuchanerror?() A.Youperformedrollbackaftercommit.B.Ifalogswitchoccursinyourdatabase.C.Thearchiverfailstogenerateanarchivedlogfile.D.Instancerecoveryfailstofindoneoftheredologfiles.E.Along-runningqueryisunabletogetread-consistentimage.F.Ifyouperformmanualundomanagementoperationsinautomode. ” 相关考题
考题 ViewtheExhibitandexaminetheattributesofanundotablespace.InanOLTPsystem,theuserSCOTThasstartedaqueryonalargetableinthepeaktransactionalhourthatperformsbulkinserts.Thequeryrunsformorethan15minutesandthenSCOTTreceivesthefollowingerror:ORA-01555:snapshottoooldWhatcouldbethereasonforthiserror()A.Thequeryisunabletogetaread-consistentimage.B.ThereisnotenoughspaceinFlashRecoveryArea.C.Thereisnotenoughfreespaceintheflashbackarchive.D.Thequeryisunabletoplacedatablocksinundotablespace

考题 Youstartedalongtransaction.Beforecommitting,youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror:ORA-01555:snapshottoooldHowwouldyoupreventsuchanerrorinthefuture?() A.guaranteeundoretentionB.addonemoreredologgroupC.sizetheredologfilesappropriatelyD.sizetheUNDOtablespaceappropriatelyE.sizetheSYSTEMtablespaceappropriatelyF.configureanappropriateundoretentionintervalG.changeautomaticundomanagementtomanual

考题 YouworkasadatabaseadministratorforCertkiller.com.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA-01555:snapshottoooldInwhichsituationwouldyoureceivesuchanerror?() A.Youperformedrollbackaftercommit.B.Ifalogswitchoccursinyourdatabase.C.Thearchiverfailstogenerateanarchivedlogfile.D.Instancerecoveryfailstofindoneoftheredologfiles.E.Along-runningqueryisunabletogetread-consistentimage.F.Ifyouperformmanualundomanagementoperationsinautomode.

考题 ORA-01555的应对方法?