多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespac

第1题：

Which two statements are true regarding the database in ARCHIVELOG mode？（）

• A、You have to shut down the database to perform the backups.
• B、Archiving information is written to the data files and redo log files.
• C、You can perform complete database backups without closing the database.
• D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
• E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

第2题：

You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

• A、You must shut down the database instance to perform the backups.
• B、You must configure the Flash Recovery Area （FRA） for the database.
• C、You can perform complete database backups without closing the database.
• D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

第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题：

Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）

• A、ARCHIVELOG mode.
• B、NOARCHIVELOG mode.
• C、Open database backups.
• D、Consistent whole backups.

第5题：

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

• A、 True
• B、 False

第6题：

For which database operation would you need the database to be in the MOUNT state（）

• A、renaming the control files
• B、re-creating the control files
• C、dropping a user in your database
• D、dropping a tablespace in your database
• E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

第7题：

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

第8题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

• A、The database is in mount state.
• B、One of the tablespaces is offline.
• C、One of the tablespaces is read only.
• D、The database operates in ARCHIEVELOG mode. 
• E、The database operates in NOARCHIEVELOG mode.

第9题：

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.

第10题：

You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs.   Your colleague asks for you to comment on his plan.  Which response would be correct？（）

• A、 The plan will work as is.
• B、 The plan needs to be modified to allow for an archive-log switch after step 3.
• C、 The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
• D、 The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
• E、 The plan cannot work as presented.