You database is running an ARCHIVELOG mode. The following pa

第1题：

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.

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

You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

• A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
• B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

第5题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

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

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.

第8题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

• A、 the datafiles associated with the SYSTEM tablespace
• B、 the datafiles associated to the DATA1 tablespace
• C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
• D、 all the datafiles in the database

第9题：

Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

• A、 ALTER DATABASE DROP LOGFILE GROUP 1
• B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
• C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
• D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

第10题：

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

• A、You should perform a log switch
• B、You should make a backup of the database
• C、You should switch the database to the NONARCHIVELOG mode
• D、You should shut down the database instance and perform a complete database recovery