Your database operates in ARCHIVELOG mode and all the tables

第1题：

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.

第2题：

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.

第3题：

第4题：

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

• A、 backup database all
• B、 backup compressed database
• C、 backup as compressed backupset database
• D、 backup as compressed backup database plus archivelog all
• E、 backup as compressed backupset database plus compress archivelog all

第5题：

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

• A、Database Datafiles 
• B、Database Control Files 
• C、Online redo logs
• D、Archived redo logs 
• E、The database SPFILE 
• F、None of the above, all these files are backed up. 

第6题：

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.

第7题：

In which two cases would you perform only consistent backup？（）

• A、You are working on a database where downtime is not tolerated.
• B、You are working on a database where downtime can be tolerated.
• C、You are working on a database that operates in ARCHIVELOG mode.
• D、You are working on a database that operates in NOARCHIVELOG mode.
• E、You are working on a database where all the tablespaces are locally managed.
• F、You are working on a database where control files and redo log files are multiplexed.
• G、You are working on a database where control files and redo log files are not multiplexed.

第8题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）

• A、The database is in NOMOUNT state.
• B、The database is in ARCHIVELOG mode and the tablespace is online.
• C、The database is in ARCHIVELOG mode and the tablespace is offline.
• D、The database is in NOARCHIVELOG mode and the tablespace is online.
• E、The database is in NOARCHIVELOG mode and the tablespace is offline.

第9题：

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.

第10题：

Which is the correct command to put the database in ARCHIVELOG mode？（）  

• A、 alter database archivelog
• B、 alter system enable archivelog mode
• C、 alter database enable archive
• D、 alter database archivelog enable
• E、 None of the above