Your production database is running in the ARCHIVELOG mode a

第1题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

• A、archival
• B、log writer
• C、database writer
• D、system monitor
• E、process monitor
• F、change tracking writer

第2题：

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

• A、 Enable flashback logging.
• B、 Start the database in the ARCHIVELOG mode.
• C、 Issue the ALTER DATABASE FLASHBACK ON； command.
• D、 Set the FAST_START_MTTR_TARGET initialization parameter.

第3题：

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

Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

• A、only the control file, the current SPFILE, and data files
• B、only the current SPFILE and data files if autobackup is disabled
• C、only the data files and the archived redo logs
• D、the control file, current SPFILE file, data files, and archived redo logs

第6题：

In order to perform Flashback Transaction Query operations， which of these steps are required？（）

• A、 Ensure that database is running with version 10.1 compatibility.
• B、 Enable Flashback Logging.
• C、 Enable Supplemental Logging.
• D、 Ensure that the database is running with version 10.0 compatibility.
• E、 Ensure that the database is in ARCHIVELOG mode.

第7题：

You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

• A、The backups would be consistent.
• B、The backups would be inconsistent.
• C、The backups would be possible only if the database is running in ARCHIVELOG mode.
• D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
• E、The backups need to be restored and the database has to be recovered in case of a media failure

第8题：

In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）

• A、increase the size of the redo log buffer
• B、increase the number of redo log groups
• C、increase the number of log writer processes
• D、increase the number of ARCn processes
• E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

第9题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

• A、 UNTIL SEQUENCE
• B、 UNTIL SCN
• C、 UNTIL CHANGE
• D、 UNTIL CANCEL

第10题：

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