单选题

In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member?()

Aimport the database from the last export

Brestore all the members in the group from the last backup

Cdrop the lost member from the database, and then add a new member to the group

Drestore all the database files from the backup, and then perform a complete recovery 

Erestore all the database files from the backup, and then perform an incomplete recovery

正确答案

来源:www.examk.com

答案解析

相似试题
  • Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’;   Which two statements are true regarding the backup created using this command?()

    多选题查看答案

  • ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database()

    单选题查看答案

  • You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database()

    单选题查看答案

  • You issued the following statement in your SQL*Plus session:   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()

    单选题查看答案

  • Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this()

    单选题查看答案

  • Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this()

    单选题查看答案

  • In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What isthe impact of this setting()

    单选题查看答案

  • in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting()

    单选题查看答案

  • You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()

    单选题查看答案

  • You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode.   Which two statements are correct in this scenario?()

    多选题查看答案