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的应对方法?