首页计算机考试Oracle认证
(多选题)

During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery.  Which view or views would you use to determine this information?() 

A V$LOGFILE

B V$RECOVER_LOG

C V$RECOVER_DATABASE

D V$LOG_RECOVER

E V$LOG

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    What is true about this statement used during import?() imp hr/hr tables= (employee, departments) file=hr.dmp ignore=y

    答案解析

  • (单选题)

    You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process?()

    答案解析

  • (单选题)

    You are using Recovery Manager (RMAN) for backup and recovery operations. Your backup and recovery policy is such that you are performing full database backup every Tuesday and Friday. You configure RMAN using the following command:   RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;   All backup and archived redo logs generated during the current week are as follows:    Which of the following files will be listed when issuing the REPORT OBSOLETE command on Sunday? ()

    答案解析

  • (单选题)

    During the installation of Oracle Database 11g,you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.  How would this environment variable setting affect the installation?()  

    答案解析

  • (单选题)

    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?()  

    答案解析

  • (单选题)

    The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()

    答案解析

  • (多选题)

    You are trying to recover your database. During the recovery process, you receive the following error:   ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289: suggestion :  /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-00280: change 5033391 for thread 1 is in sequence #11 ORA-00278: log  file ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17  /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log  ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3   How do you respond to this error?()

    答案解析

  • (单选题)

    You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name.  Which statement is true in this case()

    答案解析

  • (单选题)

    You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()

    答案解析

快考试在线搜题