网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Youstartedalongtransaction.Beforecommitting,youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror:ORA－01555:snapshottoooldHowwouldyoupreventsuchanerrorinthefuture?()
A.guaranteeundoretention
B.addonemoreredologgroup
C.sizetheredologfilesappropriately
D.sizetheUNDOtablespaceappropriately
E.sizetheSYSTEMtablespaceappropriately
F.configureanappropriateundoretentioninterval
G.changeautomaticundomanagementtomanual
参考答案
更多 “ Youstartedalongtransaction.Beforecommitting,youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror:ORA－01555:snapshottoooldHowwouldyoupreventsuchanerrorinthefuture?() A.guaranteeundoretentionB.addonemoreredologgroupC.sizetheredologfilesappropriatelyD.sizetheUNDOtablespaceappropriatelyE.sizetheSYSTEMtablespaceappropriatelyF.configureanappropriateundoretentionintervalG.changeautomaticundomanagementtomanual ” 相关考题
考题
ViewtheExhibitandexaminetheattributesofanundotablespace.InanOLTPsystem,theuserSCOTThasstartedaqueryonalargetableinthepeaktransactionalhourthatperformsbulkinserts.Thequeryrunsformorethan15minutesandthenSCOTTreceivesthefollowingerror:ORA-01555:snapshottoooldWhatcouldbethereasonforthiserror（）A.Thequeryisunabletogetaread-consistentimage.B.ThereisnotenoughspaceinFlashRecoveryArea.C.Thereisnotenoughfreespaceintheflashbackarchive.D.Thequeryisunabletoplacedatablocksinundotablespace
考题
YouworkasadatabaseadministratorforSupportcenter.cn.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA－01555:snapshottooold,Inwhichsituationwouldyoureceivesuchanerror?()
A.Youperformedrollbackaftercommit.B.Ifalogswitchoccursinyourdatabase.C.Thearchiverfailstogenerateanarchivedlogfile.D.Instancerecoveryfailstofindoneoftheredologfiles.E.Along-runningqueryisunabletogetread-consistentimage.F.Ifyouperformmanualundomanagementoperationsinautomode.
考题
YouworkasadatabaseadministratorforCertkiller.com.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA－01555:snapshottoooldInwhichsituationwouldyoureceivesuchanerror?()
A.Youperformedrollbackaftercommit.B.Ifalogswitchoccursinyourdatabase.C.Thearchiverfailstogenerateanarchivedlogfile.D.Instancerecoveryfailstofindoneoftheredologfiles.E.Along-runningqueryisunabletogetread-consistentimage.F.Ifyouperformmanualundomanagementoperationsinautomode.
考题
ORA-01555的应对方法？
热门标签
最新试卷