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

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 group

B、 perform redo log file import

C、 perform an incomplete recovery

D、 perform a redo log recovery using Recovery Manager （RMAN）

E、 shut down the database and open the database in the NOARCHIVELOG mode

查看正确答案
更多“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？（）”相关的问题
第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题
[单选题] 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.  

点击查看答案
第4题
[单选题] 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.  

点击查看答案
第5题
[单选题] 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  

点击查看答案
第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题
[单选题] 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  

点击查看答案
第8题
[单选题] Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）

A、 The database will operate normally without generating any redo.  B、 The database will hang， and you must shut down and restart the instance.  C、 The database will crash， and you must recover the database from the point of failure.  D、 The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.  

点击查看答案
第9题
[单选题] 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）.  

点击查看答案
第10题
[单选题] You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

A、Shared pool   B、Control file   C、SGA   D、PGA  

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

请使用微信扫码支付

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