单选题You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A The database would open normally.B The database would not open， and it would stop 

题目
单选题
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）
A

The database would open normally.

B

The database would not open， and it would stop at mount stage.

C

The database would open after automatically performing instance recovery.

D

The database would not open， and you have to perform database recovery to open it.

相似考题

1.You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state， but all the background processes will be restarted.

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

3. You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）A、The backups would be consistent.B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure

4. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

更多“单选题You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A The database would open normally.B The database would not open， and it would stop ”相关问题

  • 第1题：

    You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

    • A、The database would open normally.
    • B、The database would not open， and it would stop at mount stage.
    • C、The database would open after automatically performing instance recovery.
    • D、The database would not open， and you have to perform database recovery to open it.

    正确答案:C

  • 第2题：

    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第3题：

    You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）

    • A、Execute the ALTER DATABASE ARCHIVELOG statement
    • B、Select ARCHIVELOG option in the database control and restart the database to apply the changes.
    • C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
    • D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.

    正确答案:B,D

  • 第4题：

    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）

    • A、 clear the redo log group
    • B、 perform redo log file import
    • C、 perform an incomplete recovery
    • D、 perform a redo log recovery using Recovery Manager （RMAN）
    • E、 shut down the database and open the database in the NOARCHIVELOG mode

    正确答案:A

  • 第5题：

    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）

    • A、Execute the ALTER DATABASE ARCHIVELOG statement 
    • B、Select ARCHIVELOG option in the database control and restart the database to apply the changes. 
    • C、Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. 
    • D、Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement. 

    正确答案:B,D

  • 第6题：

    You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）

    • A、The backups would be consistent. 
    • B、The backups would be inconsistent.
    • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
    • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
    • E、The backups need to be restored and the database has to be recovered in case of a media failure.

    正确答案:B,C,E

  • 第7题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

  • 第8题：

    单选题
    You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
    A

    The instance would hang.

    B

    The instance needs to be shut down.

    C

    The instance would be in the open state.

    D

    The instance would abort in such cases.

    E

    The instance would be in the open and invalid state.

    F

    The instance would in the open state， but all the background processes will be restarted.


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

  • 第9题：

    单选题
    You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）
    A

    Start the instance and open the database， instance recovery automatically recoverscontrol files

    B

    Create a file based on the contents of the trace file and save it to the control file locations and start the database

    C

    Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）

    D

    Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    E

    Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.


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

  • 第10题：

    单选题
    You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）
    A

    Start the instance and open the database, instance recovery automatically recovers control files 

    B

    Create a file based on the contents of the trace file and save it to the control file locations and start the database 

    C

    Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 

    D

    Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 

    E

    Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.


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

  • 第11题：

    单选题
    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）
    A

     Restore the latest whole backup，perform complete recovery，and open the database normally 

    B

     Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.

    C

     Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.

    D

     Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.


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

  • 第12题：

    多选题
    You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    Select ARCHIVELOG option in the database control and restart the database to apply the changes.

    C

    Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

    D

    Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.


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

  • 第13题：

    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第14题：

    Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）

    • A、The database remains open.
    • B、The database gets dismounted.
    • C、The database becomes read only.
    • D、The database instance gets aborted.
    • E、The database gets shut down automatically.
    • F、The status of the database depends on the status of the USERS tablespace.

    正确答案:A

  • 第15题：

    You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）

    • A、Shut down the instance， copy the control file to the third location and open the database.
    • B、Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
    • C、Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.
    • D、Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
    • E、Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.

    正确答案:D

  • 第16题：

    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

    • A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
    • B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
    • C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
    • D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

    正确答案:D

  • 第17题：

    You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

    • A、Start the instance and open the database, instance recovery automatically recovers control files 
    • B、Create a file based on the contents of the trace file and save it to the control file locations and start the database 
    • C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
    • D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
    • E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    正确答案:D

  • 第18题：

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

  • 第19题：

    多选题
    You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）
    A

    The backups would be consistent.

    B

    The backups would be inconsistent.

    C

    The backups would be possible only if the database is running in ARCHIVELOG mode.

    D

    The backups would be possible only if the database is running in NOARCHIVELOG mode.

    E

    The backups need to be restored and the database has to be recovered in case of a media failure.


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

  • 第20题：

    单选题
    Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
    A

    Restore the latest whole backup, perform complete recovery, and open the database normally

    B

    Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

    C

    Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

    D

    Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


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

  • 第21题：

    多选题
    You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）
    A

    The backups would be consistent.

    B

    The backups would be inconsistent.

    C

    The backups would be possible only if the database is running in ARCHIVELOG mode.

    D

    The backups would be possible only if the database is running in NOARCHIVELOG mode.

    E

    The backups need to be restored and the database has to be recovered in case of a media failure


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

  • 第22题：

    单选题
    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
    A

     clear the redo log group

    B

     perform redo log file import

    C

     perform an incomplete recovery

    D

     perform a redo log recovery using Recovery Manager （RMAN）

    E

     shut down the database and open the database in the NOARCHIVELOG mode


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

  • 第23题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

相关内容