单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A You can perform online whole database backups.B You can performofflinewhole database backups.C You cannot 

第1题：

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.

第2题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

• A、You need to perform the restore and recover operations manually, because the backup was made manually. 
• B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
• C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
• D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

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

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  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.

第5题：

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.

第6题：

Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas 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.

第7题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

• A、Hot backup
• B、Online backup
• C、consistent backup
• D、incremental backup
• E、inconsistent backup

第8题：

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

• A、You must have change tracking enabled in your database
• B、Your database must be running in NOARCHIVELOG mode
• C、To back up a tablespace, it must be in backup mode
• D、To back up a tablespace, it must first be taken offline

第9题：

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

• A、The destination must be global only.
• B、A maximum of five destinations can be assigned.
• C、A maximum of ten different destinations can be assigned.
• D、All the destinations are determined by the server automatically.
• E、The destination may be local or remote for a Standby Database.
• F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

第10题：

Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

• A、You can perform online whole database backups.
• B、You can performofflinewhole database backups.
• C、You cannot perform schema-level export/import operations.
• D、You can perform the backup of only the SYSTEM tablespace when the database is open.