单项选择题
You work as a database administrator for Certkiller .com. Users in the Certkiller .com 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 undotablespace
相关考题
-
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.WhileloadingdataintotheCertkillerSTAFFtableusingOracleEnterpriseManager10gDatabaseControl，youfindthestatusofthejobasfailed.Onfurtherinvestigation，youfindthefollowingerrormessageintheoutputlog：ORA-01653unabletoextendtableHR.CertkillerSTAFFby8intablespaceUSERSWhichtaskwouldyouperformtoloadthedatasuccessfullywithoutaffectingtheuserswhoareaccessingthetable？（）
A.Restart the database instance and run the job
B.Truncate the Certkiller STAFF table and run the job
C.Delete all rows from the Certkiller STAFF table and run the job
D.Increase the size of the USERStablespacethe and run the job
E.Increase the size of the database default permanenttablespaceand run the job -
单项选择题
InyourCertkiller.comdatabaseservertheparameterPLSQL_CODE_TYPEhasbeensettoNATIVE.Whichobjectwouldbeachievedbythesetting？（）
A.The source PL/SQL code will be stored in native machine code.
B.The source PL/SQL code will be stored in interpreted byte code.
C.The compiled PL/SQL code will be stored in native machine code.
D.The compiled PL/SQL code will be stored in interpreted byte code. -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.OnaMondaymorning，youfindthedatabaseinstanceaborted.Afterinspectingthealertlogfile，youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue？（）
A.PMON coordinates media recovery.
B.SMON coordinates instance recovery.
C.PMON coordinates instance recovery.
D.Undo Advisor would roll back all uncommitted transactions.
E.SQL*PLUS reports an error with the message asking you to perform instance recovery.
