违法和不良信息举报 联系客服
免费注册 登录

The online redo̳

题目

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
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring 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 data files

正确答案:C

第2题：

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

  • A、 Database datafiles
  • B、 Control files
  • C、 Archived redo logs
  • D、 Online redo logs
  • E、 Flashback logs

正确答案:A,B,D

第3题：

Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)

A. Database datafiles

B. Control files

C. Online redo logs

D. Database pfiles

E. Archived redo logs


参考答案：C, D

第4题：

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.

正确答案:C

第5题：

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

正确答案:B

第6题：

以下（）进程负责将Redo Log buffer里的数据写入Online redo log files。

  • A、CKPT
  • B、ARCn
  • C、LGWR
  • D、DBWn

正确答案:C

第7题：

As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

  • A、 Shut down the database
  • B、 Clear the online redo log
  • C、 Back up the database
  • D、 Checkpoint the database
  • E、 Call Oracle support

正确答案:D

第8题：

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?（）

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B. ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG


参考答案：C

第9题：

You have the following online redo log configuration：    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）

  • A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；
  • B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；
  • C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；
  • D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；
  • E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；
  • F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；

正确答案:A,C

第10题：

When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）  

  • A、 To indicate the location of the auxiliary-instance online redo logs.
  • B、 To indicate the location of the target database datafiles.
  • C、 To indicate the location of the auxiliary-instance control file and online redo logs.
  • D、 To indicate the location of the auxiliary-instance database datafiles.
  • E、 This is not a valid parameter when duplicating a database.

正确答案:D

更多相关问题
相关内容