After performing a clean shut down of the database instance 

第1题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

第2题：

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

• A、On startup， SMON coordinates instance recovery.
• B、On startup， CKPT coordinates instance recovery.
• C、On startup， use RMAN to perform instance recovery.
• D、Uncommitted changes will be rolled back after the database is opened.
• E、On startup， perform media recovery and then instance recovery.
• F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

第3题：

第4题：

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.

第5题：

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.

第6题：

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.

第7题：

Your archive-log destination directory runs out of space. What is the impact of this on the database？（）  

• A、 None. The database will switch over to the stand-by archive-log destination directory.
• B、 A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.
• C、 The database will shut down，and will not restart until you correct the out-of-space situation.
• D、 The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.
• E、 Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.

第8题：

第9题：

Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）  

• A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
• B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
• C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
• D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

第10题：

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