单选题A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）AThe database allows only que

题目
单选题
A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）
A

 The database allows only queries； no other statements are allowed.

B

 The database re-creates the missing redo log files automatically.

C

 The database continues to function normally with the existing files.

D

 The database returns an error and the database instance shuts down.

E

 The user sessions that generate redo logs are terminated automatically.

相似考题

1.Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）A、RECOVER LOGFILE BLOCK GROUP 2；B、ALTER DATABASE DROP LOGFILE GROUP 2；C、ALTER DATABASE CLEAR LOGFILE GROUP 2；D、ALTER DATABASE RECOVER LOGFILE GROUP 2；E、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；

2.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？（）A、 import the database from the last exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery

3.You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A、The instance would normally abort.B、The instance would not be affected.C、The instance would be invalid， so would have to be aborted.D、The instance would remain open， but the LGWR process would fail.E、The instance would remain open and would automatically create the missing file

4. You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

更多“单选题A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）A  The database allows only q”相关问题

  • 第1题：

    A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

    • A、 The database re-created the missing redo log files automatically.
    • B、 The database continues to function normally with the existing files.
    • C、 The database allows only queries， no other statements are allowed.
    • D、 The database returns and error and the database instance shuts down.
    • E、 The user sessions that generate redo logs are terminated automatically.

    正确答案:D

  • 第2题：

    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）.

    正确答案:B

  • 第3题：

    A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.  

    • A、 1，3，4，and 5
    • B、 7，3，4. and 5
    • C、 2，3，4，and 5
    • D、 7，4，3，and 5
    • E、 Only 6 is required

    正确答案:B

  • 第4题：

    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.

    正确答案:D

  • 第5题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）
    A

    The instance would normally abort.

    B

    The instance would not be affected.

    C

    The instance would be invalid， so would have to be aborted.

    D

    The instance would remain open， but the LGWR process would fail.

    E

    The instance would remain open and would automatically create the missing file


    正确答案： E
    解析： 暂无解析

  • 第7题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.
    A

     1，3，4，and 5

    B

     7，3，4. and 5

    C

     2，3，4，and 5

    D

     7，4，3，and 5

    E

     Only 6 is required


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）
    A

    Cancel-based

    B

    Recovery using a backup control file

    C

    Time-based

    D

    Change-based


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    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？（）
    A

    import the database from the last export

    B

    restore all the members in the group from the last backup

    C

    drop the lost member from the database， and then add a new member to the group

    D

    restore all the database files from the backup， and then perform a complete recovery 

    E

    restore all the database files from the backup， and then perform an incomplete recovery


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）
    A

    RECOVER LOGFILE BLOCK GROUP 2；

    B

    ALTER DATABASE DROP LOGFILE GROUP 2；

    C

    ALTER DATABASE CLEAR LOGFILE GROUP 2；

    D

    ALTER DATABASE RECOVER LOGFILE GROUP 2；

    E

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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？（）
    A

     import the database from the last export

    B

     restore all the members in the group from the last backup

    C

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

    D

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

    E

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


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    In your database， the Log Writer （LGWR）  process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

    • A、The database instance aborts.
    • B、The database operation temporarily halts till the member becomes available.
    • C、Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
    • D、The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
    • E、The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

    正确答案:C,D

  • 第15题：

    As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）

    • A、Cancel-based
    • B、Recovery using a backup control file
    • C、Time-based
    • D、Change-based

    正确答案:A

  • 第16题：

    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

    正确答案:D

  • 第17题：

    多选题
    In your database， the Log Writer （LGWR）  process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
    A

    The database instance aborts.

    B

    The database operation temporarily halts till the member becomes available.

    C

    Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.

    D

    The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.

    E

    The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.


    正确答案： B,D
    解析： 暂无解析

  • 第18题：

    单选题
    You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）
    A

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.

    B

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    C

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    D

     Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    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）.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
    A

    The online redo log files and archived redo log files are required to accomplish the recovery.

    B

    The uncommitted transaction will be committed at the next startup of the database instance.

    C

    The uncommitted transaction is rolled back automatically at the next opening of the database.

    D

    The DBA has to perform the recovery on the database to recover the uncommitted transaction


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.  Which command would you execute to proceed further？（）
    A

    RECOVER LOFIEL BLOCK GROUP 2；

    B

    ALTER DATABASE DROP LOGFILE GROUP 2；

    C

    ALTER DATABASE CLEAR LOGFILE GROUP 2；

    D

    ALTER DATABASE RECOVER LOGFILE GROUP 2；

    E

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；


    正确答案： D
    解析： 暂无解析

相关内容