多选题Which three statements are true about Flashback Database?（）AFlashback logs are written sequentially, and are archived.BFlashback Database uses a restored control file to recover a database.CThe Oracle database automatically creates, deletes, and reside

第1题：

Which three statements regarding the server parameter file （SPFILE） are true（）

• A、An SPFILE is a binary file.
• B、An SPFILE cannot reside on a client.
• C、An SPFILE cannot contain static parameters.
• D、An SPFILE can store changes persistently across instance restarts.
• E、An SPFILE can be read by the database server， but it is not written to by the server.
• F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database.

第2题：

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

• A、 The log sequence is reset to 0.
• B、 All the online redo logs are deleted.
• C、 All the archived redo logs from a previous incarnation become useless.
• D、 The full database backup taken from a previous incarnation can be used in future.
• E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

第3题：

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

• A、The database crashes.
• B、The DBA needs to re-create the file.
• C、The file gets re-created automatically.
• D、The file gets restored automatically from the last backup.
• E、The DBA needs to perform a complete database recovery.
• F、The DBA needs to perform an incomplete database recovery.

第4题：

Which three statements are true about Flashback Database?（）

• A、Flashback logs are written sequentially, and are archived.
• B、Flashback Database uses a restored control file to recover a database.
• C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

第5题：

Which three statements are true about database recovery operations？（）

• A、Damaged or lost data files are restored from backups.
• B、Redo log file entries are used to roll forward the database.
• C、Undo segments are used to roll back any uncommitted transactions.
• D、Transactions that were active when the failure occurred are restarted.
• E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

• A、SYSDATE should not be used with TIMESTAMP.
• B、The database must have multiplexed redo log files.
• C、The database must be in the MOUNT state to execute the command.
• D、The database must be opened with the RESETLOGS option after the flashback operation.
• E、The entire database needs to be restored from the most recent backup before the flashback operation.

第14题：

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

第15题：

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

第16题：

The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

• A、until SCN
• B、until time
• C、until cancel
• D、using backup control file

第17题：

You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery 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.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：