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.

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 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 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.

Which three statements are true about using flashback database in a multitenant container database(CDB)?() A. The root container can be flashed back without flashing back the pluggable databases (PDBs).B. To enable flashback database, the CDB must be mounted.C. Individual PDBs can be flashed back without flashing back the entire cdb.D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

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

Your Oracle Database 10g is online when you execute the following statement:        SQLALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;   What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()A、 The database does not record flashback logs for MY_TABLESPACEB、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D、 None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

Flashback Database relies on which technologies to recover to a point in time?()  A、 Flashback Data ArchiveB、 Flashback logs in the flash recovery areaC、 FlashbUndo tablespaceD、 RMAN command lineE、 None of the above

Which three statements are true about using flashback database in a multitenant container database(CDB)?()A、The root container can be flashed back without flashing back the pluggable databases (PDBs).B、To enable flashback database, the CDB must be mounted.C、Individual PDBs can be flashed back without flashing back the entire cdb.D、The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.E、A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

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 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 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?()A、 Flashback logs are not deleted.B、 Flashback logs are deleted automatically.C、 Flashback logs are deleted only if you are using Recovery Manager (RMAN)D、 Flashback logs are deleted only if you are using Oracle Manager Files (OFM)E、 Flashback logs are deleted only if you are using Automatic Storage Management (ASM)

These are the details about V$FLASHBACK_DATABASE_STAT:  SQL DESC V$FLASHBACK_DATABASE_STAT Name Null? Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? ()A、BEGIN_TIME is the time at which Flashback logging is enabled.B、END_TIME is the time at which the query is executed on the view.C、REDO_DATA is the number of bytes of redo data written during the interval.D、This view contains information about flashback data pertaining to the last 24 hours.E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

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 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;

Which three actions are required to configure the Flashback Database? ()A、set Flash Recovery AreaB、enable Flashback loggingC、create FLASHBACK tablespaceD、start the database in the ARCHIVELOG modeE、start the database in the NOARCHIVELOG mode

These are the details about V$FLASHBACK_DATABASE_STAT: SQL DESC v$FLASHBACK_DATABASE_STAT  Name                    Null?              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()A、 BEGIN_TIME is the time at which Flashback logging is enabled.B、 END_TIME is the time at which the query is executed on the view.C、 REDO_DATA is the number of bytes of redo data written during the interval.D、 This view contains information about flashback data pertaining to the last 24 hours.E、 FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

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.

多选题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.

多选题These are the details about V$FLASHBACK_DATABASE_STAT:  SQL DESC V$FLASHBACK_DATABASE_STAT Name Null? Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? ()ABEGIN_TIME is the time at which Flashback logging is enabled.BEND_TIME is the time at which the query is executed on the view.CREDO_DATA is the number of bytes of redo data written during the interval.DThis view contains information about flashback data pertaining to the last 24 hours.EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.

单选题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?()A Flashback logs are not deleted.B Flashback logs are deleted automatically.C Flashback logs are deleted only if you are using Recovery Manager (RMAN)D Flashback logs are deleted only if you are using Oracle Manager Files (OFM)E Flashback logs are deleted only if you are using Automatic Storage Management (ASM)

单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()A DBWnB RECOC RVWRD LGWR

多选题These are the details about V$FLASHBACK_DATABASE_STAT: SQL DESC v$FLASHBACK_DATABASE_STAT  Name                    Null?              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()ABEGIN_TIME is the time at which Flashback logging is enabled.BEND_TIME is the time at which the query is executed on the view.CREDO_DATA is the number of bytes of redo data written during the interval.DThis view contains information about flashback data pertaining to the last 24 hours.EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.

多选题Which three actions are required to configure the Flashback Database?()Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode

多选题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.

单选题Flashback Database relies on which technologies to recover to a point in time?()A Flashback Data ArchiveB Flashback logs in the flash recovery areaC FlashbUndo tablespaceD RMAN command lineE None of the above

单选题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;

单选题Your Oracle Database 10g is online when you execute the following statement:        SQLALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;   What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()A The database does not record flashback logs for MY_TABLESPACEB The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

多选题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.