多项选择题
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）
A.By multiplexing the control files
B.By multiplexing the redo log files
C.By decreasing the size of redo log files
D.By configuring mean time to recover （MTTR） to a lower value
E.By setting the UNDO_RETENTION parameter to a higher value
相关考题
-
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.UsersintheCertkiller.comPRODdatabasecomplainabouttheslowresponseoftransactions.Whileinvestigatingthereasonyoufindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）
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.
