多项选择题

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

点击查看答案

上一题目录下一题

相关考题

单项选择题

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

单项选择题

In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

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.

单项选择题

You work as a database administrator for Supportcenter.cn. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

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.