Youstartedalongtransaction.Beforecommitting,youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror:ORA－01555:snapshottoooldHowwouldyoupreventsuchanerrorinthefuture?()A.guaranteeundoretentionB.addonemoreredologgroupC.sizethere

题目
Youstartedalongtransaction.Beforecommitting,youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror:ORA－01555:snapshottoooldHowwouldyoupreventsuchanerrorinthefuture?()

A.guaranteeundoretention

B.addonemoreredologgroup

C.sizetheredologfilesappropriately

D.sizetheUNDOtablespaceappropriately

E.sizetheSYSTEMtablespaceappropriately

F.configureanappropriateundoretentioninterval

G.changeautomaticundomanagementtomanual

相似考题

1.ViewtheExhibitandexaminetheattributesofanundotablespace.InanOLTPsystem,theuserSCOTThasstartedaqueryonalargetableinthepeaktransactionalhourthatperformsbulkinserts.Thequeryrunsformorethan15minutesandthenSCOTTreceivesthefollowingerror:ORA-01555:snapshottoooldWhatcouldbethereasonforthiserror（）A.Thequeryisunabletogetaread-consistentimage.B.ThereisnotenoughspaceinFlashRecoveryArea.C.Thereisnotenoughfreespaceintheflashbackarchive.D.Thequeryisunabletoplacedatablocksinundotablespace

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

3.ORA-01555的应对方法？

4.YouworkasadatabaseadministratorforSupportcenter.cn.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA－01555:snapshottooold,Inwhichsituationwouldyoureceivesuchanerror?()A.Youperformedrollbackaftercommit.B.Ifalogswitchoccursinyourdatabase.C.Thearchiverfailstogenerateanarchivedlogfile.D.Instancerecoveryfailstofindoneoftheredologfiles.E.Along-runningqueryisunabletogetread-consistentimage.F.Ifyouperformmanualundomanagementoperationsinautomode.

相关内容