Oracle认证考试

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、 

题目

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).
如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第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题:

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()

  • A、SMON would automatically restore the lost file.
  • B、You would need to restore the whole database from the last backup.
  • C、You would need to restore the file from the last full database backup.
  • D、You would need to use flashback technology to restore the lost redo log member.
  • E、You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
  • F、You would need to restore the missing log file by copying one of the remaining files from the same group.

正确答案:F

第3题:

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?()

A. You should perform a log switch

B. You should make a backup of the database

C. You should switch the database to the NONARCHIVELOG mode

D. You should shut down the database instance and perform a complete database recovery


参考答案:B

第4题:

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

正确答案:B

第5题:

You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()

  • A、Archiving will be disabled because the destination for the redo log files is missing.
  • B、The database instance will shut down and the error details will be logged in the alert log file.
  • C、Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
  • D、Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

正确答案:C

第6题:

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo 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 1 ORA-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

第7题:

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;   Which action should you perform immediately after using this command?()  

  • A、 You should perform a log switch
  • B、 You should make a backup of the database
  • C、 You should switch the database to the NONARCHIVELOG mode
  • D、 You should shut down the database instance and perform a complete database recovery

正确答案:B

第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 performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()

  • A、 The archived redo log files will be overwritten.
  • B、 The archived redo log files are deleted automatically.
  • C、 The archived redo log files should be moved to some other location.
  • D、 The archived redo log files are still maintained because the file names are unique.

正确答案:D

第10题:

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()

  • A、ALTER DATABASE 
  • B、ALTER SYSTEM 
  • C、ALTER USER 
  • D、ALTER REDO LOG

正确答案:B

更多相关问题