单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A until the last commitB canno

第1题：

You are managing an Oracle Database 11g database with this backup strategy：  - Every Sunday night， level 0 backup is performed.  - On Monday night and subsequent days， level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true（）

• A、The backup contains all the used blocks.
• B、The backup contains all the used and unused blocks.
• C、The backup contains blocks that have changed since the last level 0 backup.
• D、The backup contains blocks that have changed since the last level 1 backup taken last week.

第2题：

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

• A、adding a new user to the database
• B、dropping a user from the database
• C、dropping a table from the database
• D、dropping a data file from a tablespace
• E、adding a new tablespace to the database

第3题：

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.

第4题：

第5题：

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.

第6题：

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

• A、 The database writer writes to a trace file， indicating that the temporary file is not found.
• B、 The database prompts for a database recovery.
• C、 The database opens normally.
• D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.

第7题：

you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

• A、 True
• B、 False

第8题：

Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

• A、Until last commit
• B、Until the time you perform recovery
• C、Until the time the date file got corrupted
• D、Until the point where the last transaction begun
• E、You cannot recover the SYSTEMtablespaceand must re-create the database.

第9题：

第10题：