单项选择题

YouworkasadatabaseadministratorforCertkiller.com.UsersintheCertkiller.comPRODdatabasecomplainabouttheslowresponseoftransactions.Whileinvestigatingthereasonyoufindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）
A.Increasetheundoreturn
B.Createmoreundosegments
C.Createanotherundotablespace
D.Increasethesizeoftheundotablespace

A.com.UsersintheCertkiller.comPRODdatabasecomplainabouttheslowresponseoftransactions.Whileinvestigatingthereasonyoufindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）
A.Increasetheundoreturn
B.Createmoreundosegments
C.Createanotherundotablespace
D.Increasethesizeoftheundotablespace

你可能感兴趣的试题

单项选择题

InyourCertkiller.comdatabaseservertheparameterPLSQL_CODE_TYPEhasbeensettoNATIVE.Whichobjectwouldbeachievedbythesetting？（）

A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.
B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.
C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.
D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.

单项选择题

YouworkasadatabaseadministratorforCertkiller.com.OnaMondaymorning，youfindthedatabaseinstanceaborted.Afterinspectingthealertlogfile，youexecutetheSTARTUPcommandinSQLPlustobringtheinstanceup.Whatstatementistrue？（）
A.PMONcoordinatesmediarecovery.
B.SMONcoordinatesinstancerecovery.
C.PMONcoordinatesinstancerecovery.
D.UndoAdvisorwouldrollbackalluncommittedtransactions.
E.SQLPLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.

A.com.OnaMondaymorning，youfindthedatabaseinstanceaborted.Afterinspectingthealertlogfile，youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue？（）
A.PMONcoordinatesmediarecovery.
B.SMONcoordinatesinstancerecovery.
C.PMONcoordinatesinstancerecovery.
D.UndoAdvisorwouldrollbackalluncommittedtransactions.
E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.