网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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的应对方法?
热门标签
最新试卷