多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur

题目

多选题

You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）

By multiplexing the control files

By multiplexing the redo log files

By decreasing the size of redo log files

By configuring mean time to recover （MTTR） to a lower value

By setting the UNDO_RETENTION parameter to a higher value

更多“多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur”相关问题

第1题

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 filesB、By multiplexing the redo log filesC、By decreasing the size of redo log filesD、By configuring mean time to recover （MTTR） to a lower valueE、By setting the UNDO_RETENTION parameter to a higher value

点击查看答案
第2题

In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）A、the V$LOG viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control

点击查看答案
第3题

You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB、 the column of the V$INSTANCE_RECOVERY viewC、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

点击查看答案
第4题

You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape

点击查看答案
第5题

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A、Nothing happensB、Oracle will automatically switch redo logs when detected C、Oracle eventually won't allow new records to be added to the database D、The instance crashes

点击查看答案
第6题

You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up

点击查看答案
第7题

A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A、 clear the redo log groupB、 perform redo log file importC、 perform an incomplete recoveryD、 perform a redo log recovery using Recovery Manager （RMAN）E、 shut down the database and open the database in the NOARCHIVELOG mode

点击查看答案

多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur

题目

更多“多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容