YouworkasadatabaseadministratorforCertkiller.com.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA－01555:snapshottoooldInwhichsituationwouldyoureceivesuchanerror?()A.Youperformedrollbackaftercommit.B.Ifalogswitchoccursinyourdatabase.C.Thearchiver

题目
YouworkasadatabaseadministratorforCertkiller.com.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA－01555:snapshottoooldInwhichsituationwouldyoureceivesuchanerror?()

A.Youperformedrollbackaftercommit.

B.Ifalogswitchoccursinyourdatabase.

C.Thearchiverfailstogenerateanarchivedlogfile.

D.Instancerecoveryfailstofindoneoftheredologfiles.

E.Along-runningqueryisunabletogetread-consistentimage.

F.Ifyouperformmanualundomanagementoperationsinautomode.

相似考题

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

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

3.ORA-01555的应对方法？

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

相关内容