违法和不良信息举报 联系客服
免费注册 登录

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 reside

题目

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.
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：B, C, D

第2题：

Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

  • A、 DBWn
  • B、 RECO
  • C、 RVWR
  • D、 LGWR

正确答案:C

第3题：

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


参考答案：B, E

第4题：

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.

正确答案:C,D

第5题：

Flashback Database relies on which technologies to recover to a point in time？（）  

  • A、 Flashback Data Archive
  • B、 Flashback logs in the flash recovery area
  • C、 FlashbUndo tablespace
  • D、 RMAN command line
  • E、 None of the above

正确答案:B

第6题：

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.

正确答案:A,C

第7题：

Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER 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_TABLESPACE
  • B、 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

正确答案:A

第8题：

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.


参考答案：E, F

第9题：

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.

正确答案:B,C,D

第10题：

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

正确答案:B,E

更多相关问题
相关内容