搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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 LOGFILE 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；

查看正确答案
更多“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？（）”相关的问题
第1题
[单选题] Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？ （）

A、current redo log and inactive redo log  B、checkpoint position to end of redo log  C、beginning of redo log to end of redo log  D、all redo logs before the point of last commit  E、beginning of redo log to checkpoint position  

点击查看答案
第2题
[单选题] Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）

A、current redo log and inactive redo log  B、checkpoint position to end of redo log  C、beginning of redo log to end of redo log  D、all redo logs before the point of last commit  E、beginning of redo log to checkpoint position  

点击查看答案
第3题
[单选题] The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）

A、 V$LOG  B、 V$LOGFILE  C、 DBA_LOG_GROUPS  D、 V$LOG_HISTORY  

点击查看答案
第4题
[单选题] Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？（）

A、Transactions are rolled back using redo log files.  B、Transactions are rolled forward using redo log files.  C、Transactions are rolled back using redo log files and archived log files.  D、Transactions are rolled forward using redo log files and rolled back using redo log files.  

点击查看答案
第5题
[单选题] Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）

A、Transactions are rolled back using redo log files.  B、Transactions are rolled forward using redo log files.  C、Transactions are rolled back using redo log files and archived log files.  D、Transactions are rolled forward using redo log files and rolled back using redo log files.  

点击查看答案
第6题
[单选题] The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） 

A、 The database will hang.  B、 The database will be crashed.  C、 The database will be shut down.  D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group  

点击查看答案
第7题
[单选题] Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

A、 The redo log file should belong to an active group.  B、 The redo log file should belong to an inactive group.  C、 The redo log file should belong to the current group.  D、 The redo log file can be dropped only if all the transactions are stopped.  E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.  

点击查看答案
第8题
[单选题] 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 files  B、 RMAN obsolete backups  C、 multiplexed online redo log files  D、 archived redo logs that have not been copied to tape  

点击查看答案
第9题
[单选题] When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  

A、 log_file_name_convert  B、 convert_log_file_name  C、 file_name_convert_log  D、 redo_log_file_name_convert  E、 logfile_convert_directory  

点击查看答案
第10题
[单选题] The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）

A、Inactive and current redo log files are required to accomplish recovery.  B、Online and archived redo log files are required to accomplish instance recovery.  C、All redo log entries after the last checkpoint are applied from redo log files to data files.  D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服