单项选择题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
A.The database is in mount state.
B.One of the tablespaces is offline.
C.One of the tablespaces is read only.
D.The database operates in ARCHIEVELOG mode.
E.The database operates in NOARCHIEVELOG mode.
相关考题
-
多项选择题
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）
A.Increase the size of redo log files
B.Increase the size of redo log buffer
C.Increase the number of redo log files
D.Place the redo log files on a separate disk
E.Decrease the number of redo log groups to two
F.Increate the number Log Writer （LGWR） process -
单项选择题
You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）
A.RECOVER LOFIEL BLOCK GROUP 2；
B.ALTER DATABASE DROP LOGFILE GROUP 2；
C.ALTER DATABASE CLEAR LOGFILE GROUP 2；
D.ALTER DATABASE RECOVER LOGFILE GROUP 2；
E.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2； -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.Inyourdatabaseserver，theparameterPLSQL_OPTIMIZE_LEVELhasbeensetto2.Whatwouldthissettingachieve？（）
A.It degrades the run time and compiler performance.
B.It provides better run time and compiler performance.
C.It provides better optimization of the statement during parse time.
D.It forces the rule based optimizer to be used for statement optimization.
E.It provides better run time performance but slightly degraded compiler performance.
F.It provides better run time performance but slightly degraded run time performance.
