多选题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 resides flashback logs in the Fast RecoveryArea.DFlashback Database can recover a database to the state that it was in before a reset logs operation.EFlashback Database can recover a data file that was dropped during the span of time of the flashback.FFlashback 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.
多选题
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 RecoveryArea.
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.
参考解析
解析：
暂无解析
相关考题：
You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?() A. The database must have multiplexed redo logs for the flashback to succeed.B. The database must be MOUNTED for the flashback to succeed.C. The database must use block change tracking for the flashback to succeed.D. The database must be opened in restricted mode for the flashback to succeed.E. The database must be opened with the RESETLOGS option after the flashback is complete.F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A、 DBWnB、 RECOC、 RVWRD、 LGWR
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.
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.
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： SQLALTER 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.
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 filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
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.
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
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 RecoveryArea.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.
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 SCNB、until timeC、until cancelD、using backup control file
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.
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.
多选题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？（）AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation
多选题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 resides flashback logs in the Fast RecoveryArea.DFlashback Database can recover a database to the state that it was in before a reset logs operation.EFlashback Database can recover a data file that was dropped during the span of time of the flashback.FFlashback 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.
多选题Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）AMount the container database (CDB) and restore the control file from the control file auto backup.BRecover and open the CDB in NORMAL mode.CMount the CDB and then recover and open the database, with the RESETLOGS option.DOpen all the pluggable databases.ERecover each pluggable database.FStart the database instance in the nomount stage and restore the control file from control file auto backup.
多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block.
多选题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（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure.
多选题Which three statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database.
单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A DBWnB RECOC RVWRD LGWR
多选题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（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure
多选题Which three statements are true about database recovery operations？（）ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DTransactions that were active when the failure occurred are restarted.ETransactions that were active when the failure occurred are automatically committed during the recover procedure.
多选题Which two statements are true about Oracle Managed Files (OMF)?（）AOMF cannot be used in a database that already has data files created with user-specified directions.BThe file system directions that are specified by OMF parameters are created automatically.COMF can be used with ASM disk groups, as well as with raw devices, for better file management.DOMF automatically creates unique file names for table spaces and control files.EOMF may affect the location of the redo log files and archived log files.
多选题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？ （）ASYSDATE should not be used with TIMESTAMP.BThe database must have multiplexed redo log files.CThe database must be in the MOUNT state to execute the command.DThe database must be opened with the RESETLOGS option after the flashback operation.EThe entire database needs to be restored from the most recent backup before the flashback operation.
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）AFlashback logs are not deleted.BFlashback logs are deleted automatically.CFlashback logs are deleted only if you are using Recovery Manager （RMAN）.DFlashback logs are deleted only if you are using Oracle Managed Files （OMF）.EFlashback logs are deleted only if you are using Automatic Storage Management （ASM）.
多选题You want to flash back a test database by five hours.You issue this command:SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）AThe database must have multiplexed redo logs for the flashback to succeed.BThe database must be MOUNTED for the flashback to succeed.CThe database must use block change tracking for the flashback to succeed.DThe database must be opened in restricted mode for the flashback to succeed.EThe database must be opened with the RESETLOGS option after the flashback is complete.FThe database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.