black

1Z0-042

登录

单项选择题

You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. 
What would you do to overcome this problem?()

A.Increase the undo return
B.Create more undo segments
C.Create another undotablespace
D.Increase the size of the undo tablespace

相关考题

单项选择题 InyourSupportcenter.cndatabaseservertheparameterPLSQL_CODE_TYPEhasbeensettoNATIVE.Whichobjectwouldbeachievedbythesetting?()

单项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.OnaMondaymorning,youfindthedatabaseinstanceaborted.Afterinspectingthealertlogfile,youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue?()

单项选择题 InyourSupportcenter.cnproductiondatabase,youfindthatthedatabaseusersareabletocreateandreadfileswithunstructureddata,availableinanylocationonthehostmachinefromanapplication.Youwanttorestrictthedatabaseuserstoaccessfilesinaspecificlocationonthehostmachine.Whatcoulddotoachievethis?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064