● The （74） scheme in a database system is responsible for the detection of failures and for the restoration of the database to a state that existed before the occurrence of the failure.（74）A. queryB. testC. checkD. recovery

第1题：

第2题：

第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 plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

• A、 The database must have multiplexed redo log files
• B、 The database must be in the MOUNT state to execute the command
• C、 The database must be in the NOMOUNT state to execute the command
• D、 The database must be opened in RESTRICTED mode before this operation
• E、 The database must be opened with the RESETLOGS option after the flashback operation

第5题：

You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

• A、The database would open normally.
• B、The database would not open， and it would stop at mount stage.
• C、The database would open after automatically performing instance recovery.
• D、The database would not open， and you have to perform database recovery to open it.

第6题：

To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

• A、OPEN
• B、MOUNT
• C、NOMOUNT
• D、CLOSE

第7题：

Which two statements about workload capture and replay operations are true?（）

• A、The clients must be created manually on the test machines to perform more realistic testing.
• B、Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
• C、Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
• D、The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

第8题：

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

• A、 Yes， if the database is in ARCHIVELOG mode
• B、 Yes， if the database is in NOARCHIVELOG mode
• C、 No， the backup is not usable in any way
• D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

第9题：

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

• A、import the database from the last export
• B、restore all the members in the group from the last backup
• C、drop the lost member from the database， and then add a new member to the group
• D、restore all the database files from the backup， and then perform a complete recovery 
• E、restore all the database files from the backup， and then perform an incomplete recovery

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）

• A、The online redo log files and archived redo log files are required to accomplish the recovery.
• B、The uncommitted transaction will be committed at the next startup of the database instance.
• C、The uncommitted transaction is rolled back automatically at the next opening of the database.
• D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

第16题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

• A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
• C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

第17题：

In which case would you use the Flashback Database feature to perform a recovery？（）

• A、to recover a dropped tablespace
• B、to recover data from a truncated table
• C、to recover a data file that has been shrunk
• D、to recover a database to the state that existed before the RESETLOGS operation

第18题：

Which two are characteristics of user-managed backup and recovery operations？（）

• A、Recovery is initiated using SQL*Plus.
• B、Database files are backed up using SQL commands.
• C、Database files are backed up with Recovery Manager.
• D、Database files are restored using Recovery Manager.
• E、Database files are backed up using operating system commands.

第19题：

You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

• A、Multiplex all database files.
• B、Configure the Flash Recovery Area.
• C、Configure the database instance for ARCHIVELOG mode.
• D、Configure the FAST_START_MTTR_TARGET initialization parameter

第20题：

Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）

• A、failures because a data file is renamed by error
• B、failures when no standby database is configured
• C、failures that require no archive logs to be applied for recovery
• D、failures due to loss of connectivity-for example, an unplugged disk cable

第21题：

You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

• A、Multiplex all database files
• B、Configure the Flash Recovery Area.
• C、Configure the database instance for ARCHIVELOG mode.
• D、Configure the FAST_START_MTTR_TARGET initialization parameter.

第22题：

第23题：